Applies to
SSAS
Description
When Analysis Services memory utilization crosses the configured Low-limit, a process known as the “cleaner” is woken up and starts “evicting” older/lesser used objects out of memory on a periodic basis to make room for new objects.
This performance counter measures the total amount of memory freed from cache since start of cache service. This counter also measures expired object memory. A high level of evictions may indicate memory pressure.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Try and put SSAS databases on very fast (ideally solid-state disks) storage devices
- Partition large cubes which reduces logical IO requests
- Add more physical memory to the computer
- Set the HardMemoryLimit on the SSAS instance
Additional research
Performance Monitoring for SSAS – Perfmon Counter Cheat Sheet
Performance Counters (SSAS)
Determining SSAS Aggregation Usage
