Procedure Cache Hit Ratio

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  June 20, 2014 at 4:40 am

  #290207

  Hi all

  I'm putting together some monitor scripts, have buffer cache ratio etc etc but struggling to get an accurate script for the current procedure cache hit ratio...any pointers?

  Regards

  D

  'Only he who wanders finds new paths'

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  June 20, 2014 at 7:37 am

  #1723591

  Of course, it's here!

  http://sqlmonitormetrics.red-gate.com/plan-cache-hit-ratio/

  'Only he who wanders finds new paths'