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
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)
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)
Fixing RESOURCE_SEMAPHORE Waits
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock