I'm seeing something that I think is unusual in Performance Monitor. In the
Cache Hit Ration counter, my "Adhoc SQL Plans" consistently have a higher
count than my "Procedure Plans"; about 80 for Procedure and 92 for Adhoc.
I would think since Procedure plans are compiled, I would get a higher hit
ratio here than in Adhoc. Am I not correct? If I am correct, what would
this tell me? Do I need to do something so my sprocs get a higher hit