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.