本文提供SQL Server中缓存占用及脏页占用情况的查询脚本，通过这些脚本可以详细了解数据库的缓存使用状况及哪些数据库存在较多的脏页。
--缓存占用
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
扫一扫
304
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
