Analysis Services uses multi-threading for many operations, improving overall server performance by running multiple jobs in parallel. A long parsing thread is a parsing pool for all requests that do not fit within a single network message.
This performance counter measures the total number of jobs in the queue of the long parsing thread pool. Exceeding maximum thread count can lead to a slowdown in task execution.
DBAs, Server administrators, BI developers
- Consider setting PerNumaNode on the IOProcess thread pool to further optimize thread scheduling and execution
- Consider adding more CPU core
- Increase the Process MaxThreads setting from the default value of 64 to 128
- Review your partitioning strategy