Revision: 25358
Updated Code
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
Updated Code
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
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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