Bonus: Abnormal Parallelism

In another module in this class, we explain normal ranges of CXPACKET, CXCONSUMER, and LATCH_EX that you’ll see during a typical workload. We how to mitigate “normal” parallelism waits with changes to Cost Threshold for Parallelism and MAXDOP. However, I say that just by changing those two settings alone, you may still run into abnormal...