This performance counter monitors the total number of entries that are currently stored in memory cache of the Analysis Services engine.
The value of this counter is reset whenever the service is restarted.
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
PowerShell Scripts for Collecting SSAS-related Perfmon and xEvent Trace Data
Microsoft SQL Server 2008 Analysis Services: Monitoring query performance
Why doesn’t SSAS cache the entire cube?
Performance Counters (SSAS)