This performance counter keeps track of the rate of jobs through the query thread pool.
When the value of this performance counter is greater than zero then it indicates that there are more queries than query threads.
DBAs, Server administrators, BI developers
- Consider adding more CPU core
- To determine the current limits on an existing system, check out the msmdsrv.log file
- Consider setting PerNumaNode on the IOProcess thread pool to further optimize thread scheduling and execution
- Review your partitioning strategy