BI performance counter: Total Queries

Applies to



Analysis Services Data Mining supports four types of queries; Prediction Queries, Content Queries, Drillthrough Queries, and Data Definition Queries. This performance counter monitors the total number of data mining queries received by the server. If this number does not increase, then no queries are being run against the server.

Resolved by

DBAs, Network administrators

Suggested solutions

  1. Use SQL Server Profiler to trace Data Mining queries
  2. The Prediction Query Builder is helpful for starting queries that you will customize later
  3. For Unlimited concurrent DM queries, consider upgrading your SQL Server license to Enterprise
  4. Use DMVs to Monitor Analysis Services

Additional research

SSAS: Using DMV Queries to get Cube Metadata
Why doesn’t SSAS cache the entire cube?
Performance Counters (SSAS)
Counting Number of Queries Executed in SSAS

⇐ Back to index