Advanced Search

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