22-25 April 2026
SQLBits 2015

Wait watchers-Gain Performance Increases Fast!

In this session you'll learn all about SQL Server wait statistics. These are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions.
We're all told to watch our weight and to exercise more, so to flip this on its head I will be showing you exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastry’s not provided).

In this session you will learn all about SQL Server’s wait statistics, these are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions on which areas of your environment to tune to greater effect.

After attending this session you will be able to know where to find, interpret and use this information to tie down problem areas in your SQL Server estate not to fix that problem query, but improve overall performance for all of your users.

Speakers

Richard Douglas

Richard Douglas's previous sessions

Improving SQL Server Performance with Indexing
Indexing presents daunting challenges for even the most seasoned professionals, it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment & improve the overall performance of your apps
 
Investigate TempDB like Sherlock Holmes
Learn how to investigate the mysterious case of SQL Server performance problems in TempDB.
 
Alerting; Beyond the Basics
We'll look at events that you should be monitoring, how you can use various services & IoT enabled devices to alert you in ways that were never possible. You'll leave with a new outlook of how teams can be notified to fix problems faster than ever.
 
The Big Backup Theory
In this session, you'll gain invaluable guidance for optimizing your backup strategies. Using trace flags the session will cover how SQL Server manages its own backup options and how you can tune them to meet your SLAs.
 
Wait watchers-Gain Performance Increases Fast!
In this session you'll learn all about SQL Server wait statistics. These are statistics the database engine stores about the resources it is waiting on. Armed with this information you as a SQL Server professional can make better informed decisions.
 
The Day After Tomorrow; Why You Need to Baseline
Ensuring top performance is never easy. To maintain performance you need to make sure you’re monitoring the right things. How do you know if the figures you’re seeing are good or bad? Baseline comparisons can help.