BI performance counter: Short parsing job queue

Applies to

SSAS

Description

Processing of dimensions and partitions and querying of partitions are handled by job operations.

This performance counter measures the total number of jobs in the queue of the short parsing thread pool. CPU is underutilized when processing pool job queue length is greater than 0. This means that SSAS wants to process more but does not have available threads.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Check the CPU utilization, the level of concurrency, and the average query duration
  2. Increase the Process MaxThreads setting from the default value of 64 to 128
  3. Consider adding more CPU core
  4. Review your partitioning strategy
  5. Try to use faster storage (SSD) or more disk drives for quicker responses to Storage Engine requests

Additional research

Job Queue Length
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet
Performance Counters (SSAS)

⇐ Back to index