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.