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

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.

Find query bottlenecks using wait statistics • Understand CPU and disk related waits • Tune queries using wait based insights