InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 00:41:45 GMT20http://www.sqlservercentral.com/Forums/Topic1314167-1357-1.aspx[quote][b]jshurak (6/14/2012)[/b][hr]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.[/quote]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.aspxThu, 14 Jun 2012 08:09:45 GMTbradmcgehee@hotmail.comhttp://www.sqlservercentral.com/Forums/Topic1314167-1357-1.aspxExcellent 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.Thu, 14 Jun 2012 07:13:54 GMTjshurakhttp://www.sqlservercentral.com/Forums/Topic1314167-1357-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/ssc+clinic/91250/">SSC Clinic: Can Implementing &quot;Optimize for Ad Hoc Queries&quot; Boost Performance for the SQLServerCentral.com and Simple-Talk.Com SQL Servers?</A>[/B]Mon, 11 Jun 2012 18:13:39 GMTbradmcgehee@hotmail.com