/
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.
Open SQL Server Management Studio
Connect to the Analysis instance
Right click the instance and open properties
Select General
Locate the LowMemoryLimit and TotalMemoryLimit variables
Adjust the values to reflect the percentage of Total physical memory that should be allocated to SSAS
Default values are 65% and 80% respectively
A little trial and error may be necessary to fine tune the memory allocation
, multiple selections available,
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