What perfmon counters should I track for improvements to the query plan cache?
- by Bill Paetzke
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.
What should I track in perfmon regarding this? How could I report on this change? (I'd also accept an answer that queries the DMV tables or whatever else to report on the change).