cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

SQL Server - getting past CXPACKET

Working to figure out what is causing issues with a parallel query.  Query should finish in 9 seconds and took 2+ hours.

Looking at query wait times in DPA all I see is CXPACKET.  This describes the wait times of the main consumer thread.  But it does not tell me what the 8 producer threads were waiting on.  The producer threads are doing the actual work.

How do I find the wait states and times of the parallel query producer threads?

0 Kudos
1 Reply
Level 17

@often_confused_dba 

Currently, DPA does not break out the worker threads in that manner. You will need to examine the query plan to find the operators that were running in parallel and examine to see if the threads had a balanced workload. HTH

0 Kudos