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
- Use the values of this counter to benchmark the performance of a processing workload
- Use SQL Server Profiler to monitor processing commands
- 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)