BI performance counter: Total rows read

Applies to

SSAS

Description

Processing a partition sends some messages back, among these the information how many rows were processed. This performance counter relates to the measurement of Analysis Services processing of data and it monitors the total number of rows that were actually read from source into a partition when it was processed.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Use the values of this counter to benchmark the performance of a processing workload
  2. Use SQL Server Profiler to monitor processing commands
  3. Store your source data files in a SAN environment that will be easier to process

Additional research

Number of rows in a partition
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet
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