BI performance counter: Quota KB

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

  1. Add more physical memory to the computer
  2. Use HardMemoryLimit setting to adjust out-of-memory condition
  3. 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

 

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