Description
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
Resolved by
DBAs and Developers
Suggested solutions
- 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
Additional research
Troubleshooting the CXPACKET wait type in SQL Server
Five SQL Server Settings to Change
What MAXDOP setting should be used for SQL Server