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.
DBAs, Server administrators, BI developers
- Add more physical memory to the computer
- Use HardMemoryLimit setting to adjust out-of-memory condition
- Monitor your memory usage using DMVs
SSAS Performance Monitor Counters
Performance Counters (SSAS)
Understanding SQL Server Memory Grant and Memory Management