App Control: RAM for SQL Server Has Gone to Severity Red
searchcancel
App Control: RAM for SQL Server Has Gone to Severity Red
book
Article ID: 288712
calendar_today
Updated On: 11-03-2022
Products
Carbon Black App Control (formerly Cb Protection)
Issue/Introduction
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.'
Environment
App Control Server: All Supported Versions
Microsoft SQL Server: All Supported Versions
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 Information
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.