Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Mastering Server Tuning
Before the Class
Prerequisites
Introductions and Overview
Download the Slide Decks
How to Measure a SQL Server's Performance
Metrics 1 & 2: Database Size & Batch Requests/sec
Metric 3: Wait Time Ratio
Brent Analyzes Your Server's Wait Stats (35:40)
How to Fix PAGEIOLATCH Waits
What PAGEIOLATCH Means and How to Fix It
Lab 1 Setup: Fix a Server Having PAGEIOLATCH Waits
Lab 1: Brent's Solution
How to Fix SOS_SCHEDULER_YIELD Waits
What SOS_SCHEDULER_YIELD Means and How to Fix It
Lab 2 Setup: Fix a Server Having SOS_SCHEDULER_YIELD Waits
Lab 2: Brent's Solution
How to Fix Misleading Waits
What CXPACKET and CXCONSUMER Means and How to Fix It
Plan Caching and Parameterization
Lab 3 Setup: Fix a Mixed Workload
Lab 3: Brent's Solution (37:36)
How to Fix LCK% Waits
What LCK% Means and How to Fix It
Lab 4 Setup: Fix a Complicated Workload
Lab 4: Brent's Solution
How to Fix Poison Waits
What THREADPOOL Means and How to Fix It
What RESOURCE_SEMAPHORE Means and How to Fix It
Hardware-Sounding Waits: WRITELOG, HADR_SYNC_COMMIT, ASYNC_NETWORK_IO
The Architecture Lab
Lab 5 Setup: Assess a Problem, Fix It, and Plan for the Future
Lab 5: Brent's Solution
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 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