BI performance counter: Current KB

Applies to

SSAS

Description

This performance counter measures the current in-memory size (in kilobytes) used by the aggregation cache of the Analysis Services engine.

The value of this counter is reset whenever the service is restarted.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

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

Additional research

Microsoft SQL Server 2008 Analysis Services: Monitoring query performance
SSAS Performance Monitor Counters
Performance Counters (SSAS)

 

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