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.
(no tags)
- Downloads
Sorry, there are no downloads available for this session.
- SpeakerBIO
Christina Leo has been working in the information technology industry since 1998. She began her career in the I.T. world as a VB6 developer and has been working almost exclusively with SQL Server for the past three years. A puzzle solver, by nature, her favorite part of database work is performance tuning.
She works as a database developer for ProfitStars, a Jack Henry Company, supporting three development teams that create software for the banking industry.
She actively participates in the SQL Server community, is part of the leadership team for the Nashville SQL Server User Group in the United States, volunteers with PASS (Professional Association for SQL Server), and holds a double MCITP for SQL Server 2005 in Development and Administration.
- Video
The video is not available to view online.
- Session Files Explorer
Could not find a part of the path '\\sqlbits01\DENALI\SQLBitsFiles\'.