BI performance counter: Total evictions 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 To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time. ⇐ Back to index
