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

  1. Try and put SSAS databases on very fast (ideally solid-state disks) storage devices
  2. Partition large cubes which reduces logical IO requests
  3. Add more physical memory to the computer
  4. 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