SQL Server Analysis Services Memory Usage High

Owned by Knowledge Assistant
Dec 16, 2021
1 min read





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



Additional Information

https://docs.microsoft.com/en-us/analysis-services/server-properties/memory-properties?view=asallproducts-allversions