Hyland Software, Inc. recommends using the two server memory options, Minimum server memory (MB) and Maximum server memory (MB), to configure the amount of memory (in megabytes) available in the buffer pool used by an instance of Microsoft SQL Server.
By default, SQL Server can change its memory requirements dynamically, based on available system resources. When SQL Server uses memory dynamically, it queries the system periodically to determine the amount of free physical memory available. SQL Server increases or shrinks the buffer cache to keep free physical memory between 4 MB and 10 MB, depending on server activity. This prevents Windows from paging data to disk. If there is less memory free, SQL Server releases memory to Windows that usually goes on the free list. If there is more memory free, SQL Server recommits memory to the buffer cache. SQL Server adds memory to the buffer cache only when its workload requires more memory; a server at rest does not increase its buffer cache. The default setting for Minimum server memory (MB) is 0, and the default setting for Maximum server memory (MB) is 2147483647.
Within SQL Server, reduce the number of megabytes for maximum memory to a value below the maximum memory that exists on the server. This value should be anywhere from 2GB to 20GB less than the memory on the server, depending on the total amount of memory. A good rule of thumb for calculations is to leave 1–2 GB for the OS, an additional 1 GB for each 4 GB of RAM installed from 4 GB to 16 GB, and an additional 1 GB for each 8 GB of RAM installed above 16 GB. Example values are shown in the table below.
|
Server Memory (GB) |
Memory to Reserve (GB) |
Memory to Allocate to SQL Server (GB) |
|---|---|---|
|
4 |
2 |
2 |
|
8 |
3 |
5 |
|
12 |
4 |
8 |
|
16 |
5 |
11 |
|
24 |
6 |
18 |
|
32 |
7 |
25 |
|
48 |
9 |
39 |
|
64 |
11 |
53 |
Running instances of the OnBase Client on the server for processing or printing purposes is not recommended. However, if you plan to run instances of the OnBase Client on the server for processing or printing purposes, you must further reduce the Maximum server memory (MB) value to allow adequate memory to be available for those applications.
Set the Minimum server memory (MB) to 0 or a value that is less than the Maximum server memory (MB). Specifically, set the Maximum server memory (MB) to a value between 500 MB and 2 GB less than the maximum memory for the server.