BI performance counter: Memory size rows

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services processing of aggregations in MOLAP data files and it monitors the current row size of current aggregations in memory.

Resolved by

DBAs, Server administrators

Suggested solutions

  1. Avoid doing unnecessary aggregations
  2. Reduce the number of attributes in the dimensions
  3. Increase the size of your disk storage drive

Additional research

What is the recommended size of the aggregation part of a partition for SSAS 2008?
Performance Counters (SSAS)
Designing Effective Aggregations in AS2005

See more

Check out SpotLight, a free, cloud based SQL Server monitoring tool to easily detect, monitor, and solve SQL Server performance problems on any device

 

⇐ Back to index