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
Slide Deck 3.2 MB
Demo Code 43 KB