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
- You can automate predictions by including a Data Mining Query transformation in a SSIS package
- Use SQL Server Profiler to trace Data Mining queries
- 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)
