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.
DBAs, Server administrators, BI developers
- 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
SSAS Performance Monitor Counters
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet
Performance Counters (SSAS)