BI performance counter: Concurrent DM queries

Applies to



This performance counter monitors the total number of Analysis Services Data Mining queries being actively worked on.

This performance counter requires administrator rights on the server in order for the data to be collected by the agent. As such this performance counter is configured to leverage the “SQL Server Monitoring Account” RunAs profile that is provided with the SQL Server.

Resolved by

DBAs, Network administrators

Suggested solutions

  1. For Unlimited concurrent DM queries, consider upgrading your SQL Server license to Enterprise
  2. Use DMVs to Monitor Analysis Services
  3. Use SQL Server Profiler to trace model processing

Additional research

SSAS 2012: Data Mining Prediction: Concurrent DM Queries Rule
Using Integration Services with Data Mining
Performance Counters (SSAS)
Analysis Services Features Supported by the Editions of SQL Server 2016

⇐ Back to index