Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control : SQL Server Consumes High Memory in a Single-Tier Environment

App Control : SQL Server Consumes High Memory in a Single-Tier Environment

Environment

  • App Control Server: All Supported Versions
  • Microsoft SQL Server: All Supported Versions

Symptoms

  • SQL Server consumes high memory in a single tier environment
  • SQL Server is using up all the available memory on the server host

Cause

The memory limit for SQL Server is set at the default, unlimited. According to Microsoft:

By default, a SQL Server instance may over time consume most of the available Windows operating system memory in the server.
Once the memory is acquired, it will not be released unless memory pressure is detected. This is by design and does not indicate a memory leak in the SQL Server process.


Resolution

Adjust the SQL Server Maximum Memory as outlined in this article to below the total system RAM, and to match the requirements specified in the App Control Memory Configuration guide.

Additional Notes

  • 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
  • SQL Server will use all memory assigned to it.

Related Content


Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎09-20-2020
Views:
1445
Contributors