sqlserver 缓存命中率查询

最新推荐文章于 2025-03-25 15:03:36 发布

weixin_30314631

最新推荐文章于 2025-03-25 15:03:36 发布

阅读量809

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/javaleon/p/3937123.html

版权

SELECT (a.cntr_value * 1.0 / b.cntr_value) * 100.0 [BufferCacheHitRatio]
FROM (SELECT * FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio'
AND object_name = CASE WHEN @@SERVICENAME = 'MSSQLSERVER'
THEN 'SQLServer:Buffer Manager'
ELSE 'MSSQL$' + rtrim(@@SERVICENAME) +
':Buffer Manager' END ) a
CROSS JOIN
(SELECT * from sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio base'
and object_name = CASE WHEN @@SERVICENAME = 'MSSQLSERVER'
THEN 'SQLServer:Buffer Manager'
ELSE 'MSSQL$' + rtrim(@@SERVICENAME) +
':Buffer Manager' END ) b;

转载于:https://www.cnblogs.com/javaleon/p/3937123.html