AnsweredAssumed Answered

buf_cachehit_ratio formula

Question asked by GaryNG81981936 on Jul 14, 2017
Latest reply on Jul 17, 2017 by GaryNG81981936

Hi,

Wonder if any one know exactly how sqlserver probe do buf_cachehit_ratio calculation? In CA documentation it does say

The ratio is the interval number of cache hits divided by the interval number of cache look-ups”

 

But what it actually calculating? how does it actually getting the number? How can I prove to my DBA that CA is using the right formula to produce the right ratio value?

 

Hope I can get some help here. Let me know if need more detail. Thanks.

 

Gary

Outcomes