Buffer cache hit ratio ( week)

• OracleBoy

  Right there with Babe

  Points: 743

  More actions

  March 28, 2013 at 3:34 am

  #275686

  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)

  )

• Koen Verbeeck

  SSC Guru

  Points: 259165

  More actions

  March 28, 2013 at 3:42 am

  #1601509

  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