CXPACKET is probably the most confusing wait type, but things were supposed to get a little easier to interpret in SQL Server 2017 CU3 with the introduction of the CXCONSUMER wait type. We explain the difference between the two, and talk about why troubleshooting this wait is so much harder in prior versions of SQL…
2.1 How to Fix Parallelism Waits (CXPACKET, CXCONSUMER, and LATCH_EX)
CXPACKET is probably the most confusing wait type, but things were supposed to get a little easier to interpret in SQL Server 2017 CU3 with the introduction of the CXCONSUMER wait type. We explain the difference between the two, and talk about why troubleshooting this wait is so much harder in prior versions of SQL…
To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.
- 0.1 Prerequisites Before the Class
- 0.2 Download the Slides and Scripts
- 1.1 How to Measure Your SQL Server
- 1.2 How to Fix PAGEIOLATCH Waits
- 1.3 Lab 1: Fixing PAGEIOLATCH Waits
- 1.4 How to Fix CPU Waits (SOS_SCHEDULER_YIELD)
- 1.5 Lab 2: CPU-Intensive Workload
- 2.2 Plan Caching and Parameterization
- 2.3 Lab 3: Mixed Workload
- 2.4 How to Fix Blocking Waits (LCK%)
- 2.5 Lab 4 Setup: Planning the Work
- 3.1 How to Fix Worker Thread Waits (THREADPOOL)
- 3.2 How to Fix Query Memory Waits (RESOURCE_SEMAPHORE)
- 3.3 How to Fix Hardware-Sounding Waits (WRITELOG, HADR_SYNC_COMMIT, ASYNC_NETWORK_IO)
- 3.4 Lab 5 Setup: Architecture Changes
- 3.5 How to Triage Performance Emergencies
- 3.6 Lab 6 Setup: Emergency Triage
- Bonus: Abnormal Parallelism
- Bonus: Storytelling Time