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 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) 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
