SQL Server Analysis Services Memory Usage High

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

• SSMS

• SSAS

• Memory Usage

Memory limits are too high in SSAS configuration

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

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