Server Memory Options Use the two server memory options, min
server memory and max server memory, to reconfigure the amount
of memory (in megabytes) 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. The default setting for min server memory is 0, and
the default setting for max server memory is 2147483647. The
minimum amount of memory you can specify for max server memory
is 16 megabytes (MB). Setting max server memory to the minimum
value can severely reduce SQL Server performance and even
prevent it from starting. If you cannot start SQL Server after
changing this option, start it using the –f startup option and
reset max server memory to its previous value. For more
information, see Using the SQL Server Service Startup Options.
When SQL Server is using memory dynamically, it queries the
system periodically to determine the amount of free physical
memory. SQL Server uses the memory notifi