Plan Caching in SQL Server
Plan Caching is the most powerful concept in SQL Server. But on the other hand it's also the most dangerous thing that can lead to queries that are executed with a completely wrong Execution Plan. In this session we will have a more detailed look into the Plan Cache of SQL Server, in which different ways SQL Server can cache Execution Plans in the Plan Cache, and how you can troubleshooting wrong performing queries directly from the Plan Cache.
Sorry, there are no downloads available for this session.
Klaus Aschenbrenner provides SQL Server Consulting services across Europe and the US. He helps people around the world to understand, use, and run SQL Server installations in their environments. In the years 2004 - 2005 Klaus was honored with MVP awards from Microsoft for his tremendous support of the .NET Community. Klaus is also the author of the book Pro SQL Server 2008 Service Broker (ISBN 1590599993) published by Apress in August 2008.
The video is not available to view online.