How To Decipher CXPACKET Waits and Control Parallelism (4 hours)

Note: This seminar was recorded in June 2018

Learn to tune parallelism and interpret CXPACKET waits in SQL Server

Tuning parallelism has always been complicated — and with the introduction of new CXCONSUMER waits, it’s only getting more tricky to interpret.

What you’ll learn

In this four-hour recorded seminar, you’ll explore the “max degree of parallelism” and “cost threshold for parallelism” settings in SQL Server, and learn what they mean. You’ll learn what NUMA is, and how to tell if SQL Server is using Automatic Soft NUMA for advanced configuration of your SQL Server instances.

You’ll see CXPACKET and CXCONSUMER waits in action and learn how to interpret these waits in your own environments. Finally, we’ll discuss why there’s no single simple formula for MAXDOP for every SQL Server — but we’ll lay out a process which you can use to tune parallelism settings in each of your environments.

Scripts and Wait Stats/Duration Samples

https://github.com/LitKnd/SQLWorkbooks/tree/main/decipher_cxpacket_tune_parallelism

Modules

Menu