BI performance counter: Total calculation cache registered

Applies to

SSAS

Description

This performance counter relates to the measurement of Analysis Services MDX calculations. Generally, for every request, Analysis Services makes a file a request to the operating system (OS); the OS then checks to see if the file is in the cache before retrieving it from hard disk. This performance counter monitors the total number of calculation data caches registered. The msmdsrv.ini file has “LimitSystemFileCacheSizeMB” property which controls how many Analysis Services files will be cached.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. For a list of all cached files, make use of RAMMap.exe tool by Windows Sysinternals
  2. Add more physical memory to the computer
  3. Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements

Additional research

Performance tips for SSAS
Identifying Cell by Cell Computation Mode in MDX queries
Examining MDX Query performance using Block Computation
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