SQL Server Performance Forum – Threads Archive
Perfmon counter Cache manager Execution Context
Hello, as I have understand it is a best practice to monitor SQL Performance counters.
Cache Hit Ration should have a value near to 99%. When I monitor this value for a 800Gb database over here (200 users) it remains at a value of 68.9%.
When I zoom the drop from 100% seems to be related to the Cache Managers value for Execution Contexts which is at 36,6%.
What might be causing this and how to solve it? Perfmon shows:
SQLServer:Cachemanager _Total Cursors Execution Contexts Misc. Normalized Trees Prepared Plans
-Cache Hit Ratio 68,924 99,958 36,663 90,357 99,978
-Cache object Counts 26513 1405 8825 3 13981 Thanks!
May be you are confused with Buffer Cache Hit Ratio. This one should be near 99%.
In my clients I never see Cache Hit Ratio more than 70%. Luis Martin
SQL-Server-Performance.com All in Love is Fair
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
Oops….. you are so right! I think the topic can be dropped [:I] thanx!