Description
This wait accumulates during certain operations inside parallel queries. Bitmap, large binary objects and spooling operations can cause this wait type. This wait typically correlates with high CXPACKET waits and CPU utilization
Resolved by
DBAs and Developers
Suggested solutions
- Use Profiler/trace/Extended Events to determine the query causing the problem. Optimize this query to reduce the amount of parallelism required
- Investigate changing default MAXDOP and parallelism settings (links below)
Additional research
Doctor, this SQL Server appears to be sick
What MAXDOP setting should be used for SQL Server