This performance counter relates to the measurement of Analysis Services internal server memory. It monitors the total amount of memory, in kilobytes (KB), known to the background cleaner.
The total amount of memory refers to both shrinkable and non-shrinkable categories of Analysis Services internal server memory. Whilst shrinkable memory can easily be reduced and returned back to the operating system, non-shrinkable memory is not easily reduced as it is generally used for more essential system-related activities such as memory allocators and metadata objects.
DBAs, Server administrators, BI developers
- Install latest SQL Server service packs
- Monitor your memory usage using DMVs
- Add more physical memory to the computer
- Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements
To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.