SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?

Question

SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?

Brad McGehee

SSCertifiable

Points: 5282
More actions
June 11, 2012 at 6:13 pm

#262751

Comments posted to this topic are about the item SSC Clinic: Can Implementing "Optimize for Ad Hoc Queries" Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?
Brad M. McGehee
DBA

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

jshurak SSCrazy Points: 2763 More actions · Answer 1

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.

Brad McGehee SSCertifiable Points: 5282 More actions · Answer 2

jshurak (6/14/2012)
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.

Kimberly Tripp has a query at the following web page that does just that. http://www.sqlskills.com/blogs/kimberly/post/procedure-cache-and-optimizing-for-adhoc-workloads.aspx

Brad M. McGehee
DBA