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.
DBAs, Server administrators, BI developers
- Monitor your memory usage using DMVs
- Add more physical memory to the computer
- For a list of all cached files, make use of RAMMap.exe tool by Windows Sysinternals
- Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements