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.

Ask a question in the SQL Server Forums
Send Feedback