Memory Usage - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Memory Usage

Author

Topic

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2012-03-01 : 21:20:26

I need a query to check the memory usage of server and threshold and also need to identify which database or user is occupying max memory for a given period of time.

manju3606
Yak Posting Veteran

78 Posts

Posted - 2012-03-02 : 05:34:13

hi sqlfresher2k7,

Go throw the below link. i hope that will help you.

http://www.johnsansom.com/how-much-memory-is-each-sql-server-database-using/

Manju

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources