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?
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.