EXECSYNC
Short Description
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.
Detailed Description​
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.
Additional Links​
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.