• 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