Type: Advanced, self-configuring
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
1024 for the
min server memory option ...