Mastering Server Tuning with Wait Stats (Live, 3 Days, Recording)
You need to speed up a SQL Server, but you’re not sure where to begin. Is it a database problem? A query issue? Not enough hardware? Goofy SQL Server settings? Good news – I do this for a living, and I’ll teach you how in 3 days of learning and fun. Join me, Brent Ozar, as I explain how to assess your SQL Server’s bottlenecks and figure out where to focus your tuning efforts.
You’ll work along with me in a VM – each student gets their own SQL Server 2017 lab VM in the cloud with the Stack Overflow database and running workloads.
- 0.1 Prerequisites Before the Class (59 min)
- 0.2 How to Set Up Your Own Lab Server
- 1.1 Introductions and Your Lab VM (16m)
- 1.2 How to Measure Your SQL Server (89m)
- 1.3 How to Fix PAGEIOLATCH Waits (51m)
- 1.4 Lab 1: Fixing PAGEIOLATCH Waits (55m)
- 1.5 CPU Waits: SOS_SCHEDULER_YIELD (39m)
- 1.6 CXPACKET and CXCONSUMER Waits (38m)
- 1.7 Lab 2: CPU-Intensive Workload (70m)
- 2.1 Solving Waits with Readable Replicas (44m)
- 2.2 Plan Caching and Parameterization (25m)
- 2.3 Lab 3: Planning the Work (53m)
- 2.4 Trending Waits with the Power BI Dashboard (35m)
- 2.5 Lab 4: Mixed Workload (54m)
- 3.1 Poison Wait: THREADPOOL (26m)
- 3.2 Poison Wait: RESOURCE_SEMAPHORE (34m)
- 3.3 Hardware Waits: WRITELOG, HADR_SYNC_COMMIT, ASYNC_NETWORK_IO (16m)
- 3.4 Lab 5: Architecture Changes (51m)
- 3.5 How to Triage Performance Emergencies (49m)
- 3.6 Lab 6: Emergency Triage (37m)
- Bonus: Server Hardware Sizing (44m)