Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Mastering Server Tuning
Before the Class
Prerequisites
Introductions and Overview (12:42)
Download the Slide Decks
How to Measure a SQL Server's Performance
Metrics 1 & 2: Database Size & Batch Requests/sec (37:47)
Metric 3: Wait Time Ratio (36:38)
Brent Analyzes Your Server's Wait Stats (35:40)
How to Fix PAGEIOLATCH Waits
What PAGEIOLATCH Means and How to Fix It (38:55)
Lab 1 Setup: Fix a Server Having PAGEIOLATCH Waits (5:01)
Lab 1: Brent's Solution (30:20)
How to Fix SOS_SCHEDULER_YIELD Waits
What SOS_SCHEDULER_YIELD Means and How to Fix It (33:42)
Lab 2 Setup: Fix a Server Having SOS_SCHEDULER_YIELD Waits (6:45)
Lab 2: Brent's Solution (62:16)
How to Fix Misleading Waits
What CXPACKET and CXCONSUMER Means and How to Fix It (43:52)
Plan Caching and Parameterization (34:36)
Lab 3 Setup: Fix a Mixed Workload (3:37)
Lab 3: Brent's Solution (37:36)
How to Fix LCK% Waits
What LCK% Means and How to Fix It (45:14)
Lab 4 Setup: Fix a Complicated Workload (4:45)
Lab 4: Brent's Solution (40:20)
How to Fix Poison Waits
What THREADPOOL Means and How to Fix It (43:50)
What RESOURCE_SEMAPHORE Means and How to Fix It (30:16)
Hardware-Sounding Waits: WRITELOG, HADR_SYNC_COMMIT, ASYNC_NETWORK_IO (23:01)
The Architecture Lab
Lab 5 Setup: Assess a Problem, Fix It, and Plan for the Future (8:12)
Lab 5: Brent's Solution (143:23)
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)
What LCK% Means and How to Fix It
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock