O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

max server memory and min server memory

Type: Advanced, self-configuring

Default values: 2147483647 and 1024

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 1024 for the min server memory option ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required