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.
DBAs, Network administrators
- 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
Prediction Queries (Data Mining)
SSAS: Using DMV Queries to get Cube Metadata
Why doesn’t SSAS cache the entire cube?
Performance Counters (SSAS)