What's Buried in the Plan Cache?
Creating a query plan can be a time consuming and expensive process.
To avoid repeating these potentially costly steps unnecessarily, SQL Server stores its query plans, in the plan cache where they can be reused as needed.
In this session, we’ll look at how the plan cache is
organized, what plans are saved, when plans are reused and when they are
recreated, methods for observing the contents of the plan cache, and finally,
methods for manipulating plan reuse and recreation.
Christina Leo is a Boston based independent consultant specialising in T-SQL development and performance tuning. She's currently working with Adam Machanic on an investment fund management data warehouse project. Previously, she worked as a database developer for Jack Henry & Associates. She actively participates in the SQL Server community speaking at local user group meetings and SQL Saturdays. She’s also one of six Idera ACEs (Advisor and Community Educator) for 2012-2013.
The video is not available to view online.
- Session Files Explorer
The network name cannot be found.