BI performance counter: Memory Limit Hard KB

Applies to

SSAS

Description

Analysis Services uses memory limit settings to determine how it allocates and manages its internal memory.

This performance counter measures, in kilobytes (KB), the hard memory limit from the SSAS msmdsrv.ini configuration file. Memory cleaner threads monitors this metric or file setting to determine the rate at which it will begin moving data out of memory.

Resolved by

DBAs, Server administrators, BI developers

Suggested solutions

  1. Add more physical memory to the computer
  2. If there are queries that require extreme memory amounts, it generally preferable to have the query cancelled rather than the entire Windows server grind down with paging.
  3. Install latest SQL Server service packs
  4. Monitor your memory usage using DMVs

Additional research

Quick Questions
Cube performance / server memory – why used memory goes below ‘Memory Limit Low’
General monitoring for SQL Server Analysis Services using Performance Monitor
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