Limit SQL Memory Consumption
Limit the maximum memory consumption for SQL according to the table below.
|
Customer Size |
Maximum SQL memory Usage |
|---|---|
|
Small environment SQL |
4 GB |
|
Basic environment SQL |
8 GB |
|
Medium environment SQL |
16 GB |
|
Large environment SQL |
32 GB |
| ➢ | To set the SQL maximum server memory usage: |
| 1. | Connect to your database, select SQLSYSADMIN and right-click. |
| 2. | Select Properties. |
| 3. | In server Properties, select memory. |
| 4. | Set it to the maximum value (maximum server memory – 8 GB for OS and 100 MB per customer). See table above. |
| 5. | Click OK. |
