Return to Snippet

Revision: 25358
at March 29, 2010 02:51 by tvanzele


Updated Code
Select count(*)*8/1024 as ‘Cached Size (MB)’,
                Case database_id
                               When 32767 then ‘ResourceDB’
                               Else db_name(database_id)
                               End as ‘Database’
From sys.dm_os_buffer_descriptors
Group by db_name(database_id), database_id
Order by ‘Cached Size (MB)’ DESC;

Revision: 25357
at March 29, 2010 02:49 by tvanzele


Updated Code
Select count(*)*8/1024 as �Cached Size (MB)�,
                Case database_id
                               When 32767 then �ResourceDB�
                               Else db_name(database_id)
                               End as �Database�
From sys.dm_os_buffer_descriptors
Group by db_name(database_id), database_id
Order by �Cached Size (MB)� DESC;

Revision: 25356
at March 29, 2010 02:38 by tvanzele


Initial Code
Select count(*)*8/1024 as ‘Cached Size (MB)’,
                Case database_id
                               When 32767 then ‘ResourceDB’
                               Else db_name(database_id)
                               End as ‘Database’
From sys.dm_os_buffer_descriptors
Group by db_name(database_id), database_id
Order by ‘Cached Size (MB)’ DESC;

Initial URL

                                

Initial Description

                                

Initial Title
Buffer pool usage per database

Initial Tags
sql

Initial Language
SQL