4

when running a delete query to a table that has many foreign keys I get the following waits.

I noticed that I have both CXPACKETS and CXCONSUMER wait types at the same time during of the execution of my query.

the question is:

what is the relation between these 2 wait types (if any)?

enter image description here

  • 2
    Some interesting information here - CXCONSUMER wait type – history and what you need to know – Scott Hodgin Mar 7 '19 at 12:37
  • great article indeed I’ve seen control threads show both CXCONSUMER and CXPACKET, depending on what’s happening in the query - Paul Randal – Marcello Miorelli Mar 7 '19 at 12:47
  • >>>I noticed that I have both CXPACKETS and CXCONSUMER wait types at the same time<<< Your delete was executed in one session, and these two waits are from different sessions, and noone of these 2 blocks another session. There is no correlation between them – sepupic Mar 7 '19 at 13:03
2
  • CXCONSUMER occurs when a consumer thread waits for a producer thread to send rows.
  • CXPACKET occurs when trying to synchronize the query processor exchange iterator or getting a required buffer.

CXCONSUMER waits are generally benign, encountered as a normal part of parallel(CXPACKET) execution.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.