BI performance counter: Query pool job rate

Applies to

SSAS

Description

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.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Consider adding more CPU core
  2. To determine the current limits on an existing system, check out the msmdsrv.log file
  3. Consider setting PerNumaNode on the IOProcess thread pool to further optimize thread scheduling and execution
  4. Review your partitioning strategy

Additional research

SSAS Performance Monitor Counters
Performance Counters for SSAS 2008
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