17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor

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.
Presented by Christina E. Leo at SQLBits X
  • Downloads
  • SpeakerBIO
    Christina_E_Leo1.jpg

    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.

  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.