22-25 April 2026 
SQLBits 2014
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?
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. You start cursing yourself for not waiting to Monday, take off your bag and start searching for the problem. What should you do now?
In this hands-on session, we will go over the ways SQL Server gives us for tracking progress of processes and queries, and identifying bottlenecks in real-time. Among other topics, we will talk about the percent_complete column, how the CXPacket wait type can help us, to Rollback or not to Rollback, and how the new sys.dm_exec_query_profiles DMV can help us.
In this hands-on session, we will go over the ways SQL Server gives us for tracking progress of processes and queries, and identifying bottlenecks in real-time. Among other topics, we will talk about the percent_complete column, how the CXPacket wait type can help us, to Rollback or not to Rollback, and how the new sys.dm_exec_query_profiles DMV can help us.
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?