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?