Applies to
SSAS
Description
This performance counter relates to statistics related to the Analysis Services aggregation cache and it measures the total number of insertions into the cache per partition per cube per Analysis Services database. The value of this counter is usually high and is reset whenever the Analysis Services is restarted.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Try and put SSAS databases on very fast (ideally solid-state disks) storage devices
- Partition large cubes which reduces logical IO requests
- Add more physical memory to the computer
Additional research
Performance Counters (SSAS)
Determining SSAS Aggregation Usage
Storage Engine Cache Aggregation and its Implications for Dimension Design