This performance counter measures the number of times that queries unsuccessfully attempted to retrieve data from the memory cache. Expect the value of this counter to increase shortly after cube processing or Analysis Services service restart. If this number continues to grow than it may indicate insufficient memory or that queries being run are not optimal.
DBAs, Server administrators, BI developers
- Add more physical memory to the computer
- 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