Home Forums Article Discussions Article Discussions by Author Discuss content posted by Brad M. McGehee SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers? RE: SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?
jshurak
SSCrazy
Points: 2763
More actions
June 14, 2012 at 7:13 am
#1500983
Excellent write up. I've been looking into implementing this on one of my servers. Would it be helpful to look that the total composition of the plan cache to get a comparative figure? As with many things in SQL Server, numbers are relative to size.