Applies to
SSAS
Description
This performance counter measures the total number of aggregation lookups into the memory cache.
A high value for this performance counter indicates that most of your queries are using a shared reference set which could be an indication that most of your queries are optimal. The value of this counter is reset whenever Analysis Services service is restarted.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Ensure that you have enough memory to fit your cache
- Evaluate cube queries and calculations
- Partition large cubes which reduces logical IO requests
- Try and put SSAS databases on very fast (ideally solid-state disks) storage devices
Additional research
SSAS Performance Monitor Counters
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet
Performance Counters (SSAS)