BI performance counter: Total rows written

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 written into disk in s multidimensional format. If the value of this counter is much lower than number of rows read then you need to check the logical or physical disk counters.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

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

Additional research

How to Process a SSAS MOLAP cube as fast as possible – Part 2
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