BI performance counter: Available MBytes

Applies to

Operating System

Description

Reports the amount of memory in MB that is available for the operating system to use. The operating system must reserve the sufficient amount of memory in order to keep the SQL Server memory paging to minimum to prevent the dramatic performance degradation.

Resolved by

DBAs

Suggested solutions

  1. Increase the size of the allocated/physical memory
  2. Remove any unnecessary applications off the server
  3. Decrease max memory allocation of SQL to remove OS pressure, as a rule of thumb a 4GB server should have 3GB allocated to SQL and 1GB to the OS. For each additional 4GB that is added to the total allocation an additional 1GB of memory should be reserved for the OS
  4. Data page compression if CPU usage doesn’t suffer (more data can fit in memory)

Additional research

Server Memory Server Configuration Options
How to Size the SQL Server Memory & Why is it important?

 

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