While exploring the data from system health extended events for event so server diagnostics I see for column query processing XML as below:
Max workers - 2944 ( based on 80 schedulers on my server) Max workers created - 3097 Max workers available/idle - 2262 Pending tasks - 89
MS reports this as warning if there is any pending tasks greater than 1.
I am not able to understand this data from system health events that why there would be pending tasks when worker threads are already available as shown above and how are workers created more than maxworkers available as 2944 compared to created as 3097
And when should it be a concern or I should say better to interpret this information from query processing.
Wait stats since 04/20
CXPACKET - 26.8% PREEMPTIVE_OS_ENCRYPT_MESSAGE - 18.24% LATCH_EX - 17.9%
waiting task count=10407 wait time ms=29989ms max wait time=641ms signal wait time =1ms