March 28, 2013 at 3:34 am
Hi everybody , I need your help please :
I want to create a graph to show the progression of the "buffer cache hit ratio" for last 7 days (a week).
Until now I use this script (actual moment ) :
SELECT CAST(
(
SELECT CAST (cntr_value AS BIGINT)
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio'
)* 100.00
/
(
SELECT CAST (cntr_value AS BIGINT)
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Buffer cache hit ratio base'
) AS NUMERIC(6,3)
)
March 28, 2013 at 3:42 am
Please do not crosspost. It wastes peoples time and fragments replies.
Original thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1436335-1550-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply