1.6 CXPACKET, CXCONSUMER, and LATCH_EX Waits

CXPACKET is probably the most confusing wait type, but things get a little easier to interpret in SQL Server 2017 CU3 with the introduction of the CXCONSUMER wait type. We explain the difference between the two, and talk about why troubleshooting this wait is so much harder in prior versions of SQL Server. We’ll look…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Live Class Season Pass PLUS Lab VM or Mastering Server Tuning with Wait Stats, or log in if you already shelled out the cash.

Menu
{"cart_token":"","hash":"","cart_data":""}