Starting with the upcoming SQL Server 2017 CU3 and SQL Server 2016 SP2 releases, CXPACKET waits are split into an actionable wait (CXPACKET) and a negligible wait (CXCONSUMER).
(these wait types are already present in Azure SQL Database).
Month: November 2017
SQL Server Trace Flags
Microsoft have published a useful list of all SQL Server trace flags in a single location:
DBCC TRACEON – Trace Flags
In the past, some of these were poorly documented or hard to find.