For the best web experience, please use IE11+, Chrome, Firefox, or Safari

Demystifying CXPACKET and CXCONSUMER

Demystifying CXPACKET and CXCONSUMER
On Demand
  • Recorded Date:Nov. 9, 2020
  • Event:On Demand
Demystifying CXPACKET and CXCONSUMER

If you've managed database performance, you've come across the wait types CXPACKET and CXCONSUMER. You've seen a lot of conflicting instructions on how to go about fixing them, and you know that setting MAXDOP to 1 isn't the right thing to do.

Learn what happens when SQL Server parallelizes queries correctly, what causes parallelism to go awry, and what you can do about it.

Watch Your Free Webcast

Please wait...

triangle-down check
By downloading, you are registering to receive marketing email from us. To opt-out, follow steps described in our Privacy Policy.

reCAPTCHA protects this site. See Google's Privacy Policy and Terms of Use.