SQLBits 2014

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 ways the Plan Cache can help us identify performance problems.
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.