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
- Add more physical memory to the computer
- 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.
- Install latest SQL Server service packs
- 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)