This talk was recorded at NDC London in London, England. #ndclondon  #ndcconferences #developer #softwaredeveloper    

Attend the next NDC conference near you: 
https://ndcconferences.com
https://ndclondon.com/

Subscribe to our YouTube channel and learn every day:   
/        @NDC 

Follow our Social Media!

https://www.facebook.com/ndcconferences
https://twitter.com/NDC_Conferences
https://www.instagram.com/ndc_conferences/

#architecture #bigdata #database #web 

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.

NDC Conferences

A conference talk by Pinal Dave at NDC London covering SQL Server wait statistics as a rapid diagnostic tool for performance problems. The session demonstrates how to use wait stats to instantly identify whether a server is suffering from CPU, memory, or threading issues rather than spending hours on extensive analysis. Key demos show how CX packet waits reveal CPU waste from excessive parallelism, how reducing max degree of parallelism (MAXDOP) can free up threads for other queries, how resource semaphore waits indicate memory pressure, and how SOS scheduler waits signal thread context-switching problems. The core message is that wait statistics provide immediate, actionable direction on where to focus tuning efforts rather than blindly optimizing everything.

"Run Query Run" - A Fresh Look at SQL Wait Stats - Pinal Dave - NDC London 2026