EXCHANGE

Description

Similar to CXPACKET wait type, except this wait will accumulate on controller packets (thread co-ordination) rather than data packets. Occurs when lot of the long running queries are being parallelized. If processor utilisation is very (typically above 80%) this wait should be investigated

Resolved by

DBAs and Developers

Suggested solutions

  1. Examine high CPU queries to see if they can be optimised.
  2. Investigate changing default MAXDOP and parallelism settings (links below)
  3. Indexing, look for high CPU parallel queries

Additional research

Five SQL Server Settings to Change
What MAXDOP setting should be used for SQL Server

⇐ Back to index