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