22-25 April 2026 
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.
Speakers
Matan Yungman's previous sessions
The Data Loading Performance Presentation
Microsoft has a famous whitepaper called "The Data Loading Performance Guide".
On this session, we will turn the whitepaper into a presentation and see a few advanced ways to boost your data loading processes.
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.
Query Progress Tracking in SQL Server
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. What should you do now?