SQL Server View the amount of space the database occupies in the data cache

1  UseMaster2 Go3 Select *  fromsys.dm_os_buffer_descriptors4 Go5 6 --View the amount of space the database occupies in the data cache7 --128 Bytes, 1/8 kilobytes (KB) because each data page corresponds to a row in dynamic management view (management VIEW,DMV)8 --1 byte (byte) = 8 bit (bit)9 --1000 kilobytes (KB) = 1024 bytes (byte)Ten --1 megabytes (MB) = 1.024 million kilobytes (KB) One Select Count(*)*8/1024x768  as 'Cached Size (MB)', A         Casedatabase_id when 32767  Then 'Resouredb' -                         Else db_name(database_id)End  as 'Database', - database_id the  fromsys.dm_os_buffer_descriptors - Group  by db_name(database_id), database_id - Order  by 'Cached Size (MB)' desc - Go

Results:

SQL Server View the amount of space the database occupies in the data cache