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: 8389
More actions
March 30, 2013 at 8:25 pm
#1602299
I changed the advanced settings to optimize for ad hoc workloads and now the cache is much smaller but I don't expect the hit rate to go up since very few of the query plans are being reused.