September 2010
Intermediate to advanced
1704 pages
111h 8m
English
max server memory and min server memoryType: Advanced, self-configuring
Default values: 2147483647 and 0
The max server memory option specifies the maximum amount of memory (in megabytes) available to SQL Server. It is used in conjunction with min server memory, and they essentially establish upper and lower bounds for memory allocation. SQL Server uses this memory for user connections, locks, internal data structures, and caching of the data. This is the memory pool described earlier. The default value of 2147483647 for the max server memory option means that SQL Server performs dynamic allocation of memory from the operating system, based on available physical memory on the machine. The default value of 0 for the min server memory option ...