BI performance counter: Cleaner Memory KB

Applies to

SSAS

Description

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.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Install latest SQL Server service packs
  2. Monitor your memory usage using DMVs
  3. Add more physical memory to the computer
  4. Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements

Additional research

Cleaner Memory KB Perfmon Counter is Wacky
Performance Counters (SSAS)
Memory configuration (no pitfalls!) in SSAS
Why doesn’t SSAS cache the entire cube?

 

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