BI performance counter: Current models processing

Applies to

SSAS

Description

This performance counter monitors the total number of Analysis Services Data Mining models currently being processed. For systems where the default agent action account is not an administrator, you must configure the “SQL Server Monitoring Account” RunAs profile accordingly to ensure this performance data is collected.

Resolved by

DBAs, Network administrators

Suggested solutions

  1. Use DMVs to Monitor Analysis Services
  2. Use SQL Server Profiler to trace model processing
  3. Grant Full control to a database role used for processing model

Additional research

SSAS 2012: Data Mining Model Processing: Current Models Processing Rule
Why doesn’t SSAS cache the entire cube?
Performance Counters (SSAS)
Analysis Services 2008 performance counters

 

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