BI performance counter: Processing pool job rate

Applies to

SSAS

Description

A processing pool is a type of an Analysis Services worker thread pool used to process an incoming query request. Threads from the processing pool are used for activity that takes place in the storage engine including dimension scans, partition scans, and aggregation scans.

This performance counter monitors the rate of non-I/O jobs through the processing thread pool such processing ROLAP related jobs and writing new files into the storage engine cache.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. To disable per NUMA node thread pool behavior, change the value of PerNumaNode property to 0
  2. Consider adding more CPU core
  3. If you are seeing consistently high queue lengths, but not high CPU utilization you many want to adjust your MaxThreads and/or CoordinatorExecutionMode properties for your SSAS instance

Additional research

Analysis Services Thread Pool Changes in SQL Server 2012
Analysis Services 2012 Configuration settings
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