占用Buffer Pool大户汇总 占用Buffer Pool大户汇总,从数据库,表和索引三个层面统计Buffer Pool空间占用情况,脚本如下:USE master GO/*This script utility is used for calculation data pages located in buffer pool cache*/set ...
1.Buffer Pool的内存主要是由那个数据库占了?SELECT count(*)*8 as cached_pages_kb,CASE database_id WHEN 32767 THEN 'ResourceDb' ELSE db_name(database_id)END AS Database_name FROM sys.dm_os_buffer_descriptors GROUP BY db_name...
1.Buffer Pool的内存主要是由那个数据库占了?SELECT count(*)*8 as cached_pages_kb,CASE database_id WHEN 32767 THEN‘ResourceDb’ELSE db_name(database_id)END AS Database_name FROM sys.dm_os_buffer_descriptors GROUP BY db_name...
1.Buffer Pool的内存主要是由那个数据库占了?SELECT count(*)*8 as cached_pages_kb,CASE database_id WHEN 32767 THEN‘ResourceDb’ELSE db_name(database_id)END AS Database_name FROM sys.dm_os_buffer_descriptors GROUP BY db_name...
1.Buffer Pool的内存主要是由那个数据库占了?SELECT count(*)*8 as cached_pages_kb,CASE database_id WHEN 32767 THEN‘ResourceDb’ELSE db_name(database_id)END AS Database_name FROM sys.dm_os_buffer_descriptors GROUP BY db_name...