Autoplay
Autocomplete
Speed
Previous Lecture
Complete and Continue
Mastering Server Tuning
Before the Class
Prerequisites
Introductions and Overview (23:43)
Download the Slide Decks
How to Measure a SQL Server's Performance
Metrics 1 & 2: Database Size & Batch Requests/sec (28:52)
Metric 3: Wait Time Ratio (50:14)
Brent Analyzes Your Server's Wait Stats (47:49)
How to Fix PAGEIOLATCH Waits
What PAGEIOLATCH Means and How to Fix It (46:00)
Lab 1 Setup: Fix a Server Having PAGEIOLATCH Waits (8:47)
Lab 1: Brent's Solution (36:31)
How to Fix SOS_SCHEDULER_YIELD Waits
What SOS_SCHEDULER_YIELD Means and How to Fix It (42:11)
Lab 2 Setup: Fix a Server Having SOS_SCHEDULER_YIELD Waits (5:50)
Lab 2: Brent's Solution (72:54)
How to Fix Misleading Waits
What CXPACKET and CXCONSUMER Means and How to Fix It (31:36)
Plan Caching and Parameterization (33:49)
Lab 3 Setup: Fix a Mixed Workload (6:08)
Lab 3: Brent's Solution (42:34)
How to Fix LCK% Waits
What LCK% Means and How to Fix It (41:46)
Lab 4 Setup: Fix a Complicated Workload (3:20)
Lab 4: Brent's Solution (64:45)
How to Fix Poison Waits
What THREADPOOL Means and How to Fix It (35:52)
What RESOURCE_SEMAPHORE Means and How to Fix It (28:19)
Hardware-Sounding Waits: WRITELOG, HADR_SYNC_COMMIT, ASYNC_NETWORK_IO (13:55)
The Architecture Lab
Lab 5 Setup: Assess a Problem, Fix It, and Plan for the Future (5:48)
Lab 5: Brent's Solution (44:24)
How to Triage Performance Emergencies
Brent's Triage Process (36:43)
Lab 6 Setup: Triage an Emergency and Fix It (6:36)
Lab 6: Brent's Solution (28:43)
What RESOURCE_SEMAPHORE Means and How to Fix It
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock