--https://msdn.microsoft.com/en-us/library/ms189806.aspx
select *
from master..sysperfinfo
where object_name like '%Plan Cache%';
Hi I'm evaluating the free version of Solarwinds DPA and find it a promising tool from which to learn from. One of the prompts indicates that the Procedure Cache Hit Ratio is low and suggests I run this query for insight.
I looked at msdn for explanation on for cntr_value and cntr_type but get codes for cntr_type. Should I learn these codes or is there a DMV which will put something meaningful for type?
Any ideas?
Thank you
John
SQL 2012 Standard VPS Windows 2012 Server Standard