SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Administration, Memory Tuning Rss

   Items 1 to 1 of 1   

Determine SQL Server memory use by database and object

For many people, the way that SQL Server uses memory can be a bit of an enigma. A large percentage of the memory your SQL Server instance utilizes is consumed by buffer pool (essentially, data). Without a lot of digging, it can be hard to tell which of your databases consume the most buffer pool memory, and even more so, which objects within those databases. This information can be quite useful, for example, if you are considering an application change to split your database across multiple servers, or trying to identify databases that are candidates for consolidation.  Read more...
By Additional Articles 2011/06/01 | Source: MSSQLTips.com | Category: administration
Rating:  Rate this |   Briefcase | 4,806 reads
   Items 1 to 1 of 1