App Control: RAM for SQL Server Has Gone to Severity Red

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

1. Verify the Server Type is set correctly
   1. Log into the Console and navigate to Settings > System Configuration > General
   2. Click Edit and adjust the Server Type accordingly. 
   3. Save any changes.
2. Determine Required Total RAM and Memory Limit For SQL Server based on endpoint count
   1. App Control TechDocs > Server > SQL Server Configuration Guide > Memory Configuration
   2. Verify the application server hosting SQL Server has the Required Total RAM (ex: 12GB)
3. Run SQL Server Management Studio and connect to the SQL Server hosting the das database.
   1. In the left-hand pane > Object Explorer > right click Server Name > Properties > Memory.
   2. Adjust Maximum Server Memory (in MB) accordingly (ex: 8192) and click OK.
   3. Restart SQL Server (right click the Server Name > Restart).
4. 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.
• SQL Express has a built-in memory cap of 1GB.
• SQL Server Memory Configuration Options