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.
- Increase the size of the allocated/physical memory
- Remove any unnecessary applications off the server
- 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
- Data page compression if CPU usage doesn’t suffer (more data can fit in memory)
To track BI performance metrics – consider using ApexSQL BI Monitor, a web application that monitors system, SSAS, SSIS and SSRS performance in real time.