BEGIN:VCALENDAR VERSION:2.0 PRODID:-//SQLBits/com CALSCALE:GREGORIAN METHOD:PUBLISH X-MS-OLK-FORCEINSPECTOROPEN:TRUE BEGIN:VEVENT DTSTART:20120331T150000Z DTEND:20120331T160000Z LOCATION:SQLBits Conference - Bourg SUMMARY:What's Buried in the Plan Cache? DESCRIPTION: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.
X-ALT-DESC;FMTTYPE=text/html:

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 E. Leo

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.

UID:SQLBITS1391SEQUENCE:0 DTSTAMP:20130525T043516Z END:VEVENT END:VCALENDAR