Things You Can Find in the Plan Cache

The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system.
In this session we will demonstrate a few basic and advanced ways we can use the plan cache in order to identify and solve query performance problems.
Presented by Matan Yungman at SQLBits XII
  • Downloads
    Slide deck available Slide Deck 3.2 MB
    Samples available Demo Code 43 KB
    Video available MP4 Video HD 509 MB
  • SpeakerBIO
    Matan_Yungman.jpg
    Matan Yungman is a Technical Evangelist for Madeira SQL Server Services. He has over 10 years of experience working with SQL Server, focusing mainly on performance tuning, high availability, database development and database design. Matan also co-hosts the Israeli SQL Server Radio show. He is passionate about SQL Server, technology and the SQL Server community.
    http://www.dbnewsfeed.com http://www.dbnewsfeed.com/feed
  • Video