BI performance counter: Total rows converted

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services processing of data and it monitors the total number of rows that were converted from a relational source into a multidimensional format during data processing.

The value of this counter can be used to evaluate whether the amount of time taken for processing is related to amount of data 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. Use DMVs to monitor processing activity through i.e. find out what objects are consuming the most memory and CPU

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