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 total memory size, in bytes, of the current aggregations.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

1. Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements
2. Avoid doing unnecessary aggregations
3. Reduce the number of attributes in the dimensions
4. Increase the size of your disk storage drive

Additional research

Analysis Services and the Case of the Standby Cache
Performance Counters for SSAS 2008
Performance Counters (SSAS)
Designing Effective Aggregations in AS2005

⇐ Back to index