patternsqlMinor
how does CXPACKETS relates to CXCONSUMER wait types?
Viewed 0 times
typescxconsumerwaitcxpacketsrelatesdoeshow
Problem
when running a delete query to a table that has many foreign keys I get the following
I noticed that I have both
the question is:
what is the relation between these 2 wait types (if any)?
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.