Mastering Server Tuning with Wait Stats

You need to speed up a SQL Server, but you’re not sure where to begin. Is it a database problem? A query issue? Not enough hardware? Goofy SQL Server settings? Good news – I do this for a living, and I’ll teach you how in 3 days of learning and fun. Join me, Brent Ozar, as I explain how to assess your SQL Server’s bottlenecks and figure out where to focus your tuning efforts.

Labs & lectures include:

• How to use sp_BlitzFirst to identify your server’s top bottlenecks
• How to fix common wait types like CXPACKET, PAGEIOLATCH, LCK%, SOS_SCHEDULER_YIELD
• How to identify and mitigate poison wait types like RESOURCE_SEMAPHORE and THREADPOOL
• How to prove that your changes made things better
• How to decide whether configuration changes, query/index tuning, or hardware/VM changes will give you the biggest bang for the buck

Your Progress So Far in This Class

This is driven by the mark-as-complete buttons in each module of the class. (Let’s be honest: you’re probably just going to mark them as complete because you’re that kind of student. I feel you.)

Introductions

We introduce ourselves, you included, then start the first lab:

Click on the modules on the right side of the page to keep moving through the class.