A lot of the long running queries are being parallelized. This is not necessarily a bad thing but it does consume additional CPU resources. If processor utilization is very high (typically above 80%) this wait should be investigated
DBAs and Developers
- Examine high CPU queries to see if they can be optimized.
- Investigate changing default MAXDOP and parallelism settings (links below)
- Indexing, look for high CPU parallel queries
Troubleshooting the CXPACKET wait type in SQL Server
Five SQL Server Settings to Change
What MAXDOP setting should be used for SQL Server