如需獲得最佳網頁瀏覽體驗,請使用 IE 11 或更高版本、Chrome、Firefox 或 Safari。

Demystifying CXPACKET and CXCONSUMER

Demystifying CXPACKET and CXCONSUMER
在线

Nov.

9

  • 日期:Nov. 9, 2020
  • 时间: 12:00 PM – 1:00 PM EST
  • 持续时间:60 分钟
  • 位置:WebEx
  • 活动:在线
Demystifying CXPACKET and CXCONSUMER

Speaker: Brent Ozar

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.