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 31, 2013 at 2:56 am
#1602310
Would there be a benefit to using forced parameterization if the procedure cache is filled up with hundreds of these plan stubs and not much else?
If I could get the procedure cache hit rate up, I'd be thrilled.