BI performance counter: Current entries

Applies to

SSAS

Description

This performance counter monitors the total number of entries that are currently stored in memory 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

PowerShell Scripts for Collecting SSAS-related Perfmon and xEvent Trace Data
Microsoft SQL Server 2008 Analysis Services: Monitoring query performance
Why doesn’t SSAS cache the entire cube?
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