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.