0

I'm looking at the query store wait stats and getting high Parallelism wait type. Is this just a renamed CX_packet wait type?

Cheers

Alex

1 Answer 1

0

This is all documented.

16 Parallelism CXCONSUMER, CXPACKET, CXSYNC_CONSUMER, CXSYNC_PORT, EXCHANGE, HT%, BMP%, BP%

But of course, there’s nothing wrong with parallelism waits, and seeing them shouldn’t be a cause for concern.

3
  • Thanks Erik.......of course it depends how big the waits are and in this case they're causing the app to timeout. The server has default maxdop\threshold settings though
    – AlexP012
    Commented Mar 6 at 13:14
  • @AlexP012 no, CX waits won't cause timeouts, but do your thing. Commented Mar 6 at 15:05
  • Hi Erik I wouldn't normally be bothered about CX_Packet sort of waits but query store is giving me these stats for the offending query. Parallelism 70 secs, Idle 15 secs, Buffer Latch 4 secs, Unknown 0, CPU 1 secs, Latch 0, Memory 0, The application server is timing out after not receiving a reply from the SQL box in 30 seconds. The parallelism stat seems to high to ignore. Why wouldn't waits for parallelism impact the app server timeout? If you have time to answer let me know. I'm always looking to learn
    – AlexP012
    Commented Mar 7 at 8:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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