max server memory
and min server memory
Type: 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 ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.