BI performance counter: AggCacheKB

Applies to

SSAS

Description

An obvious benefit to having aggregations in Analysis Services is that you are likely to have fast running queries at the expense of incurring additional size increase of your Analysis Services database. Having some of the aggregations in memory cache can save you valuable resources. This performance counter measures, in kilobytes (KB), the total current memory allocated to the aggregation cache.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

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

Additional research

Recommended practices for SQL Server Analysis Services aggregations
Performance Counters (SSAS)
Performance Counters for SSAS 2008 Part-II
Analysis Services 2005 – Performance Counter Guidance

 

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