Environment
- App Control Server: All Supported Versions
- Microsoft SQL Server: All Supported Versions
Symptoms
A Health Indicator in the Console states:
'Health Indicator 'RAM for SQL Server' has gone to severity red. Check the Health Indicator for more details.'
Cause
The memory limit for SQL Server is not set correctly for the total number of endpoints.
Resolution
Set the memory limit for SQL Server according to the requirements specified in the SQL Server Configuration guide:
VMware Docs > Server Documentation > SQL Server Configuration Guide > SQL Permissions & Memory Configuration.
- Open SQL Server Management Studio and connect to the SQL Server hosting the das database.
- In the left-hand pane > Object Explorer > right click Server Name > Properties > Memory.
- Verify the value, 'Maximum server memory (in MB)' is set according to the OER.
- Restart SQL Server (right click the Server Name > Restart).
- Restart the App Control Server and Reporter services.
Additional Notes
- By default SQL Server is configured to use the full system memory.
- The Memory Limit required for App Control is dependent on the total Computers in App Control.
- The SQL Server Memory Configuration can be found in VMware Docs > Server Documentation > SQL Server Configuration Guide > SQL Permissions & Memory Configuration.
- SQL Express has a built-in memory cap of 1GB.
Related Content