The parallelism terms CXPACKET and MAXDOP often stump database professionals – what do they mean, and what are we supposed to do about them? You will learn how parallelism works, how it goes wrong, what basic rules to start with, and how to know when to deviate from those guidelines. You’ll understand how much CXPACKET…
2.3 Waits: CXPACKET – Parallelism Gone Wild (34m)
The parallelism terms CXPACKET and MAXDOP often stump database professionals – what do they mean, and what are we supposed to do about them? You will learn how parallelism works, how it goes wrong, what basic rules to start with, and how to know when to deviate from those guidelines. You’ll understand how much CXPACKET…
You'll need a membership to access this course. Check out my training classes.
- 0.1 Dec 27-29 Class Resources
- 1.1 Indexes: How to Think Like the Engine (110m)
- 1.2 Queries: How SQL Server Builds Plans and Cardinality Estimates (47m)
- 1.3 Indexes: How to Performance Tune Nonclustered Indexes with sp_BlitzIndex (70m)
- 1.4 Waits: LCK: Find and Fight Blocking (49m)
- 2.1 Queries: How to Identify and Fix Parameter Sniffing (84m)
- 2.2 Queries: Watch Brent Tune Queries with SQL Server 2017 (106m)
- 2.4 Waits: PAGEIOLATCH – Slow Storage (77m)
- 3.1 Processes: How to Triage Performance Emergencies (84m)
- 3.2 Waits: ASYNC_NETWORK_IO, RESOURCE_SEMAPHORE, and WRITELOG (40m)
- 3.3 DBA: Corruption 201 – Optimizing CHECKDB Performance (43m)