Is It a Problem?
Treat it like CXPACKET: evidence of parallel queries, not proof of a problem. It was zero on our SQL Server 2025 lab, where the CX waits carry the parallelism time. Get Wait Statistics does not filter it out, so if it ranks, you will see it. It becomes a signal when it ranks high on a workload that should not be running big parallel queries.
What It Means
Microsoft’s definition: it occurs during synchronization in the query processor exchange iterator during parallel queries. Exchange operators are the Distribute, Repartition and Gather Streams operators you see in a parallel plan. There is no fuller description of it published.
When It Does Matter
When it rises with complaints about particular queries, find the parallel queries doing the most work:
SELECT TOP (20)
qs.total_elapsed_time / 1000 AS total_elapsed_ms,
qs.total_worker_time / 1000 AS total_cpu_ms,
qs.execution_count,
SUBSTRING(t.text, 1, 200) AS query_start
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS t
WHERE qs.total_worker_time > qs.total_elapsed_time
ORDER BY qs.total_worker_time DESC;
Then look at their plans for skew and big scans: fresh statistics and indexes for the scan-driving predicates are the usual fixes, and MAXDOP and cost threshold covers the settings. The baseline to monitor is the CX family’s share of wait time per interval. The query needs VIEW SERVER STATE.
The CX Family
These are the parallelism waits. They prove parallel plans are running, which is often what you want, and they are read together rather than one at a time. The main page is CXPACKET and CXCONSUMER.
- CXPACKET / CXCONSUMERExchange waits. Producer and consumer threads in a parallel plan waiting on each other.The main page for this family
- CXSYNC_PORTPort synchronisation. Opening, closing and synchronising exchange ports, from SQL Server 2022.Worth a look when it climbs
- CXSYNC_CONSUMERConsumer synchronisation. Consumer threads waiting to reach an exchange synchronisation point, from SQL Server 2022.Worth a look when it climbs
- CXROWSET_SYNCParallel range scan. Child threads of a parallel range scan coordinating.Usually noise
- EXCHANGEExchange iterator. Synchronisation in the exchange iterator of a parallel query.Worth a look when it climbs. This page.
Where To Go Next
EXCHANGE is usually small next to the CX waits. If you are chasing a real problem, start with the waits that cost you time.
- CXPACKET and CXCONSUMER, the main parallelism page.
- MAXDOP and Cost Threshold for Parallelism, the two settings behind most parallel plans.
- The waits that usually matter, ranked, with what each one is telling you.
- Performance & Troubleshooting, the scripts and guides for this part of the stack.
Leave a Reply