This performance counter measures the total number of sub-cube queries that have been answered from data in memory cache since the Analysis Services service was started.
The value of this counter is generally high. It should be compared to Total Misses performance counter to evaluate the percentage of sub-cube queries that are resolved using cache.
DBAs, Server administrators, BI developers
- Add more physical memory to the computer
- 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 Counters (SSAS)
Monitoring queries with Performance Monitor counters