Product has been added to your cart.

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…

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.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Mastering Server Tuning with Wait Stats
  7. 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...
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.