Masterclass: Microsoft SQL Server Execution Plans, from Compilation to Caching to Reuse

Download

Right click “Save as…”

Slides (view online)
Execution plan reuse is one of the most important aspects of building well-performing and scalable SQL Server solutions. But it's also the one that is often overlooked during the design phase and becomes very difficult to troubleshoot later. In this session we discuss in detail the following aspects of SQL Server execution plans: compilation, re-compilation, parameterisation, caching, reuse, and aging. You will leave this session with full understanding of how to improve your server's performance by increasing execution plan reuse (and how to avoid reuse in case this is necessary).
For more information, check out this course on Microsoft Virtual Academy:

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.