BI performance counter: Total Predictions

Applies to

SSAS

Description

Predictive data mining is the most common type of data mining. This performance counter monitors the total number of data mining prediction queries received by the server. The value of this counter is reset whenever the service is restarted.

Resolved by

DBAs, Network administrators

Suggested solutions

  1. You can automate predictions by including a Data Mining Query transformation in a SSIS package
  2. Use SQL Server Profiler to trace Data Mining queries
  3. Use DMVs to Monitor Analysis Services

Additional research

Prediction Queries (Data Mining)
SSAS: Using DMV Queries to get Cube Metadata
Why doesn’t SSAS cache the entire cube?
Performance Counters (SSAS)

 

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