Skip to content
«
»
 

Find Number of Pages Each Database has in BufferPool

Posted by 
on  June 19 2009

This query shows how many pages each database has in the buffer Pool. This will show you the breakdown of memory allocation for each database. 

SELECT
   DB_NAME(database_id),
   COUNT(page_id)as number_pages
FROM sys.dm_os_buffer_descriptors
WHERE database_id !=32767
GROUP BY database_id
ORDER BY database_id


Popular search terms:
Filed under DMV Queries Tagged 
Comment (RSS)  |  Permalink

2 Comments

  1. Rafael Cruz says:
    February 4, 2011 at 9:01 am

    Worked great, but when tried to use on servers with AWE enabled i got this error:
    “Msg 208, Level 16, State 1, Line 1
    Invalid object name ‘sys.dm_os_buffer_descriptors’”.

    Is there an way to get this information on AWE enabled servers?

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»