--缓存占用
SELECT COUNT(*)*8/1024 'MB', DB_NAME(database_id) 'DATABASE'
FROM sys.dm_os_buffer_descriptors
GROUP BY DB_NAME(database_id),database_id
ORDER BY 1 DESC
--SELECT TOP 111 * FROM sys.dm_os_buffer_descriptors WHERE is_modified=1
--脏页占用
SELECT COUNT(*)*8/1024 'MB', DB_NAME(database_id) 'DATABASE',database_id
FROM sys.dm_os_buffer_descriptors
WHERE is_modified=1
GROUP BY DB_NAME(database_id),database_id
ORDER BY 1 DESC
SELECT COUNT(*)*8/1024 'MB', DB_NAME(database_id) 'DATABASE'
FROM sys.dm_os_buffer_descriptors
GROUP BY DB_NAME(database_id),database_id
ORDER BY 1 DESC
--SELECT TOP 111 * FROM sys.dm_os_buffer_descriptors WHERE is_modified=1
--脏页占用
SELECT COUNT(*)*8/1024 'MB', DB_NAME(database_id) 'DATABASE',database_id
FROM sys.dm_os_buffer_descriptors
WHERE is_modified=1
GROUP BY DB_NAME(database_id),database_id
ORDER BY 1 DESC