Plan Caching and Recompilation in SQL Server 2012
SQL Server Technical Article
Writers: Greg Low, SQL Down Under
Technical Reviewers: Paul White, Andrew Kelly, Rubén Garrigós, Kalen Delaney, Leigh Stewart, Jack Li
Published: March 2013
Applies to: SQL Server 2012
Summary: This paper explains how SQL Server 2012 allocates memory for plan caching, how query batches are cached and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations and for minimizing plan cache pollution.
To review the document, please download the Plan Caching and Recompilation in SQL Server 2012 Word document.