Occurs during parallel queries while synchronizing in query processor in areas not related to the exchange iterator. Examples of such areas are bitmaps, large binary objects (LOBs), and the spool iterator. LOBs may frequently use this wait state.
During parallel query operations, it is necessary for temporary objects to be set up. You will see the EXECSYNC wait whilst these objects are being prepared for use.
How to reduce this wait
Not available yet. Contributions welcome.
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for sqlserver - EXECSYNC
- Ecosia Search for sqlserver - EXECSYNC
- Bing Search for sqlserver - EXECSYNC