BI performance counter: Total Rows Applies to SSAS Description 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 rows returned by data mining queries. The value of this counter is reset whenever the service is restarted. Resolved by DBAs, Network administrators Suggested solutions You can also use COUNTROWS DAX function to counts the number of rows Use SQL Server Profiler to trace Data Mining queries For Unlimited concurrent DM queries, consider upgrading your SQL Server license to Enterprise 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 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
