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 Netherlands based, independent consultant specializing in T-SQL development and performance tuning. She happily shares her 14 years of technical experience with the SQL Server community by teaching at local and international SQL Server user group meetings and technical events, including multiple SQL Saturdays, SQL Bits, TechEd Africa, and the PASS Summit.