Home Forums SQL Server 2008 SQL Server 2008 - General Low Procedure Cache Hit Rate means no use of stored procedures? RE: Low Procedure Cache Hit Rate means no use of stored procedures?
PHXHoward
SSCrazy Eights
Points: 8388
More actions
April 1, 2013 at 12:58 pm
#1602572
Adding the plan guide for that one query has changed the hit rate from 60% to 99%.
I don't know if it made a performance difference though because the query plan was probably trivial but it does look better on my diagnostic screen now.