/
SQL Server Analysis Services Memory Usage High

SQL Server Analysis Services Memory Usage High





Description of Issue

SQL Server Analysis Services (SSAS) is using a high amount of memory on the server and needs to be adjusted



Context
  • SSMS

  • SSAS

  • Memory Usage



Cause

Memory limits are too high in SSAS configuration



Resolution

Adjust the memory limits in SSAS to be lower. 

  1. Open SQL Server Management Studio

  2. Connect to the Analysis instance

  3. Right click the instance and open properties

  4. Select General

  5. Locate the LowMemoryLimit and TotalMemoryLimit variables

  6. Adjust the values to reflect the percentage of Total physical memory that should be allocated to SSAS

    1. Default values are 65% and 80% respectively

    2. A little trial and error may be necessary to fine tune the memory allocation













Related content

Processing AR Cube Stuck In Status Running
Processing AR Cube Stuck In Status Running
More like this
Performance Issues in Munis Modules and Integrated Products
Performance Issues in Munis Modules and Integrated Products
More like this
The SQL Server Analysis Service Started and Then Stopped
The SQL Server Analysis Service Started and Then Stopped
More like this
Unexpected Error for Centrals programs - All users - Server memory use high
Unexpected Error for Centrals programs - All users - Server memory use high
More like this
Munis Hosting Authorized Client Testing Error
Munis Hosting Authorized Client Testing Error
More like this
Deployment Failed on Verify Cubes - Error Connecting to Analysis Server
Deployment Failed on Verify Cubes - Error Connecting to Analysis Server
More like this