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

Database Training Days 201: Demystifying CXPACKET and CXCONSUMER with Brent Ozar

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 likely encountered the wait types CXPACKET and CXCONSUMER. With so much conflicting advice on how to address these issues, it’s easy to make the wrong call—like setting MAXDOP to 1, which isn't always the right solution. In this session, Brent Ozar will guide you through what happens when SQL Server parallelizes queries correctly, what causes parallelism to go awry, and the steps you can take to fix it.

Topics that will be discussed include:

  • The role of CXPACKET and CXCONSUMER wait types in SQL Server
  • Understanding query parallelism and when it goes wrong
  • Best practices for managing and optimizing parallel queries
  • Practical solutions for resolving issues without compromising performance

Speaker:

  • Brent Ozar, Microsoft Certified Master

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.