Cxpacket:
Occurs when queries using parallelism plan.
When the parallel plan is used, the query is executed in multiple threads and the query can continue only when all parallel threads are completed.
Action to take:-
According to available processor and workload manage MAXDOP & Cost threshold of parallelism
The MAXDOP number represents the number of CPU cores SQL Server will use for parallel query execution. Default is set to 0
When the serialized query plan cost exceeds the cost threshold for parallelism it will create a parallel query plan. The CTFP is set by default to 5
From Sql Server 2016 SP2 CXPACKET is split into Consumer and producer.
Following photo show relationship between CXCONSUMER & CXPACKET, It is safe to ignore CXCONSUMER wait type:
