Workshop: Query Plan Caching and RecompilingDate: Friday, August 27, 2010 at 9:00a Pacific  If you need assistance, please use the chat system below: This is a Deep-Dive, Advanced Workshop On-demand viewing available for one week and it includes a certificate on successful completion of the post-course quiz. Help Desk and FAQ  This workshop, by Microsoft SQL Server MVP Kalen Delaney will explore what you need to know about plan caching, tools you can use when working with plan cache, best practices and much more. This workshop is an in-depth look at how and when SQL Server caches your query plans and how the choice between plan reuse and plan recompilation can significantly impact the performance of your queries and your systems overall.If you'd like more information about Kalen Delaney, the presenter, there is an excellent summary here. You'll learn about three different types of compiled plans that can be cached and reused. You'll learn about the options for controlling what plans get cached, as well as if and when reuse of the plans can occur and when that is beneficial. You'll discover the negative impact of parameter sniffing and discover how it can be prevented. Last but not least, we'll look at the metadata for exploring the plan cache contents to determine exactly what plans are cached, how often they're being reused, and what the resource cost is of your cached plans . Kalen is a foremost authority on SQL Server optimization and query plan management - she's put together this workshop as a way to bring you key information you can apply to your work with SQL Server. Appropriate use of plan caching is probably one of the most high-impact options you have in supporting your systems, allowing your query performance to be maximized, and using SQL Server to its fullest potential. This workshop will give you the information you need to be able to have the best options and approaches in place. You'll be learning from one of the most renowned and respected presenters in the world - and Kalen makes sure to present in a way that both makes sense and gives you key information you can put to use. SSWUG.ORG Workshops are not a simple webcast in these areas. We'll explain the options, show what you can watch for, see what you need to really pay attention to. Find out what's really important in this comprehensive vWorkshop. vWorkshop registration is only $99. |
