Autoplay
Autocomplete
Previous Lecture
Complete and continue
Mastering Server Tuning 2026
Before the Class
Prerequisites
Change Log for This Class
Introductions and Setting Up Lab 1 (20:01)
Watch the Live Class
Download the Slides & Demos
Fixing Memory Issues
Fixing RESOURCE_SEMAPHORE Waits (67:12)
Fixing Plan Caching Issues (39:20)
Using Query Store Safely (39:38)
Lab 1 - Brent Does it (29:34)
Fixing Blocking, Logging, and Listening Issues
Fixing LCK Waits with Isolation Levels and Replicas (45:36)
Fixing LCK Waits with ADR and Optimized Locking (38:57)
Fixing Logging and Listening Waits (30:49)
Lab 2 - Brent Does It (43:52)
Fixing CPU Issues
Fixing SOS_SCHEDULER_YIELD Waits (42:52)
Fixing THREADPOOL Waits (41:43)
Lab 3 Setup (7:50)
Lab 3 - Brent Does It (53:02)
Architecture
Tuning SQL Server with AI (103:43)
How I Misuse Resource Governor (18:40)
The Final Lab
Lab 4 Setup (5:56)
How I Misuse Resource Governor
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock