Performance Troubleshooting using Waits and Latches

One of the first things you should check when investigating performance issues are wait and latch statistics, as these can usually point you in the right direction for further analysis. SQL Server knows why executing threads have to stop and wait, so make use of that information to short-circuit your performance tuning!

Unfortunately, many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. There's a plethora of old, misguiding, or just plain wrong information out there on the Internet about what various waits mean and what you should do about them.

I'm so passionate about educating people about wait statistics that I built a resource library of more than 1,000 wait types and latch classes that tens of thousands of people around the world use every month to help with performance tuning.

In this full-day workshop, I'll teach how to investigate and interpret wait and latch statistics and how thread scheduling works inside SQL Server so you understand what’s really going on, not just what ‘the answer’ is. You'll walk away knowing how to recognize and troubleshoot very common performance bottlenecks that you can identify using wait statistics and what traditionally ‘tricky’ wait types like CXPACKET and SOS_SCHEDULER_YIELD actually mean and what you should do about them. The practical techniques you’ll learn (along with the scripts you'll get) are simple and effective and you can take them home and start using them immediately. You'll also learn what a myriad of wait and latch types actually mean and how you can investigate lightly-documented types to gain insight into what causes them. Don't waste time when it comes to performance troubleshooting; wait statistics are the easiest route to understanding your performance problems and I want to help you get there faster!


Monday 1 January 1900