Autoplay
Autocomplete
Previous Lecture
Complete and continue
Mastering Server Tuning
Before the Class
Prerequisites
Introductions and Overview (20:01)
Download the Slide Decks
Change Log for This Class
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)
Bonus: How to Triage Performance Emergencies
Brent's Triage Process (34:19)
Lab 6 Setup: Triage an Emergency and Fix It (5:21)
Lab 6: Brent's Solution (28:43)
Bonus: Off-Topic Storytelling Time
Do We Need to Optimize for Sequential Keys? (7:39)
Faster Cheaper Cloud Databases
Introduction (5:54)
Assessing Your Cloud Performance Problems (34:33)
The #1 Cloud Wait Type: PAGEIOLATCH (64:56)
The #2 Cloud Wait Type: SOS_SCHEDULER_YIELD (38:16)
Troubleshooting an Amazon RDS SQL Server Instance (30:27)
Recap (7:22)
Download the Slide Decks
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock