Applies to
SSAS
Description
Analysis Services pre-allocates a modest amount of memory at start up so that requests can be handled immediately. Additional memory is allocated as query and processing workloads increase.
This performance counter gives an indication, in kilobytes (KB), of total current Analysis Services instance’s memory quota. This can also be referred to as memory reservation or memory grant. Memory reservation improves query reliability under server load, because a query with reserved memory is less likely to hit out-of-memory while running, and the server prevents one query from dominating entire server memory.
Resolved by
DBAs, Server administrators, BI developers
Suggested solutions
- Add more physical memory to the computer
- Use HardMemoryLimit setting to adjust out-of-memory condition
- Monitor your memory usage using DMVs
Additional research
SSAS Performance Monitor Counters
Performance Counters (SSAS)
Memory Properties
Understanding SQL Server Memory Grant and Memory Management