22-25 April 2026
Video unavailable
SQLBits 2026

"Run Query Run" - A Fresh Look at SQL Wait Stats

Learn how to use SQL Server Wait Statistics to find performance bottlenecks and fix slow queries. This session covers session level waits, CPU and disk I/O delays, and practical tuning techniques you can apply immediately to make your queries run faster and more efficiently.
Wait Statistics have been a key part of SQL Server performance tuning for years, helping database professionals identify and resolve performance issues. Whether you're new to the concept or looking to improve your skills, this session will show you how to use Wait Statistics to make your queries run faster.

We’ll cover practical techniques to uncover the reasons behind slow queries and fix them. Along the way, we’ll look at new features and insights that make performance tuning more straightforward.

Here’s what we’ll focus on:

>> Finding Bottlenecks with Wait Statistics: Learn how to spot the root cause of delays in your queries.
>> Session-Level Wait Stats: See how tracking waits at the session level can provide valuable insights.
>> Understanding CPU Waits: Break down CPU-related waits and what they mean for your server’s performance.
>> Fixing Disk I/O Delays: Understand how to reduce the impact of disk waits on your queries.
>> Using Wait Stats to Tune Queries: Apply what you learn to improve indexes, joins, and query plans.

This session is for anyone who wants to improve query performance and make their SQL Server run as efficiently as possible. Join us to learn simple, actionable steps that you can start using right away.