Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering Server Tuning
Before the Class
Prerequisites
Introductions and Overview (8:43)
Download the Slide Decks
Change Log for This Class
How to Measure a SQL Server's Performance
Metrics 1 & 2: Database Size & Batch Requests/sec (27:15)
Metric 3: Wait Time Ratio (26:07)
Brent Analyzes Your Server's Wait Stats (35:40)
How to Fix PAGEIOLATCH Waits
What PAGEIOLATCH Means and How to Fix It (35:33)
Lab 1 Setup: Fix a Server Having PAGEIOLATCH Waits (4:22)
Lab 1: Brent's Solution (28:44)
How to Fix SOS_SCHEDULER_YIELD Waits
What SOS_SCHEDULER_YIELD Means and How to Fix It (38:16)
Lab 2 Setup: Fix a Server Having SOS_SCHEDULER_YIELD Waits (5:18)
Lab 2: Brent's Solution (69:56)
How to Fix Misleading Waits
What CXPACKET and CXCONSUMER Means and How to Fix It (30:59)
Plan Caching and Parameterization (26:40)
Lab 3 Setup: Fix a Mixed Workload (3:18)
Lab 3: Brent's Solution (37:36)
How to Fix LCK% Waits
What LCK% Means and How to Fix It (47:03)
Lab 4 Setup: Fix a Complicated Workload (4:42)
Lab 4: Brent's Solution (76:15)
How to Fix Poison Waits
What THREADPOOL Means and How to Fix It (36:34)
What RESOURCE_SEMAPHORE Means and How to Fix It (43:58)
Hardware-Sounding Waits: WRITELOG, HADR_SYNC_COMMIT, ASYNC_NETWORK_IO (12:07)
The Architecture Lab
Lab 5 Setup: Assess a Problem, Fix It, and Plan for the Future (6:41)
Lab 5: Brent's Solution (71:24)
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)
Change Log for This Class
Here's what's changed recently:
2025-11-15:
How to Fix LCK% Waits - added a new video to demo SQL Server 2025's new Optimized Locking.
Complete and Continue