How can an improvement to the query cache be tracked?
Posted
by Bill Paetzke
on Stack Overflow
See other posts from Stack Overflow
or by Bill Paetzke
Published on 2010-05-11T21:33:42Z
Indexed on
2010/05/11
21:44 UTC
Read the original article
Hit count: 167
I am parameterizing my web app's ad hoc sql. As a result, I expect the query plan cache to reduce in size and have a higher hit ratio. Perhaps even other important metrics will be improved.
Could I use perfmon to track this? If so, what counters should I use? If not perfmon, how could I report on the impact of this change?
© Stack Overflow or respective owner
