HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

how does CXPACKETS relates to CXCONSUMER wait types?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
typescxconsumerwaitcxpacketsrelatesdoeshow

Problem

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)?

Solution


  • 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.

Context

StackExchange Database Administrators Q#231558, answer score: 2

Revisions (0)

No revisions yet.