(Republishing, or using this info in a commercial product/website, is prohibited without permission. All other uses are permitted. If in doubt, please ask.)
Description:
The simplest explanation of this wait type is that there are parallel plans running. This wait type was added in Azure SQL Database and Azure SQL Managed Instance and is now in SQL Server 2022. This, along with CXSYNC_PORT, were split out from CXPACKET in a bid to make investigating parallel plan performance issues easier.
I do not have any experience with this wait yet.
Do not just reduce the server MAXDOP to try to reduce or remove these! See CXPACKET for more information.
(Books Online description: “Occurs with parallel query plans when waiting to reach an Exchange Iterator synchronization point among all consumer threads.”)
Questions/comments on this wait type? Click here to send Paul an email, especially if you have any information to add to this topic.
Added in SQL Server version:
Azure SQL Database, Azure SQL Managed Instance, SQL Server 2022.
Removed in SQL Server version:
N/A
Extended Events wait_type value:
TBD
Other information:
TBD
Known occurrences in SQL Server (list number matches call stack list):
TBD
Abbreviated call stacks (list number matches known occurrences list):
TBD