SELECT
ROW_NUMBER() OVER(ORDER BY CachedSize DESC) AS [Buffer Pool Rank], [Database Name]
, CachedSize AS [Cached Size (MB)]
,CAST(CachedSize / SUM(CachedSize) OVER() * 100.0 AS DECIMAL(5,2)) AS [Buffer Pool Percent]
FROM
(
SELECT DB_NAME(database_id) AS [Database Name],
CAST(COUNT(*) * 8/1024.0 AS DECIMAL (10,2)) AS [CachedSize]
FROM sys.dm_os_buffer_descriptors WITH (NOLOCK)
WHERE database_id <> 32767 -- ResourceDB
GROUP BY DB_NAME(database_id)
) AggregateBufferPoolUsage
ORDER BY [Buffer Pool Rank]
SqlServer 查看 内存 Memory 消耗情况 的语句
最新推荐文章于 2025-05-23 09:13:30 发布