BI performance counter: Long parsing job queue length

Applies to

SSAS

Description

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.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Consider setting PerNumaNode on the IOProcess thread pool to further optimize thread scheduling and execution
  2. Consider adding more CPU core
  3. Increase the Process MaxThreads setting from the default value of 64 to 128
  4. Review your partitioning strategy

Additional research

Thread Pool Properties
Performance Counters (SSAS)
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet

 

To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.

⇐ Back to index