Making parallelism waits actionable

Geschrieben von Database Magician am Montag, 13. November 2017

'During PASS we announced changes to how users will be able to make parallelism waits more actionable – specifically the “infamous” CXPACKET. This change effectively splits CXPACKET waits into an actionable wait (CXPACKET) and a negligible wait (CXCONSUMER). This change will be effective starting with upcoming SQL Server 2017 CU3 and SQL Server 2016 SP2 (this wait type is already present in Azure SQL Database).'...

https://blogs.msdn.microsoft.com/sql_server_team/making-parallelism-waits-actionable/