Home Forums SQL Server 2008 SQL Server 2008 Administration Scripts To Monitor SQL SERVER RE: Scripts To Monitor SQL SERVER
KumarVelayutham
SSCrazy
Points: 2204
More actions
April 2, 2013 at 4:55 am
#1602738
Hope after some modify,it will helps!
select [object_name], [counter_name], [cntr_value]
from master.dbo.sysperfinfo
where counter_name = 'Buffer cache hit ratio'
or counter_name = 'Buffer cache hit ratio base'
Regards,Kumar