Buffer Pool Usage by Database

Here is a quick query I wrote today. It is the first time I had to go to this DMV so I thought I would share. It would be useful when planning for consolidation and troubleshooting a bunch of apps that have been consolidated or are hosted in a shared environment. Once you find the database, you can break it down by object and index with Tom Davidson's query.

select db_name(database_id) as dbName, count(*)*8/1024 as BufferPoolMB

from sys.dm_os_buffer_descriptors

group by db_name(database_id)

order by 2 desc

email it! |   |   |   |  | 

Permalink     1 Comments  

Rate this Post: 12345
COMMENTS:

Captcha test due to comment spam.

posted @ Wednesday, September 10, 2008 9:28 AM by JasonMassie

---

Name (required)

Email (required)

Website

Notify me of followup comments via e-mail

Simple BBCode can be used like [url=http://example.com]Example[/url] and [B]