Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

65


Chapter 3: Installing SQL Server


3


when allocated. In other words, SQL Server holds on to this minimum amount of memory
even if it is no longer needed.

FIGURE 3-16
Default minimum and maximum memory settings.

Misconception


A common misconception is that SQL Server immediately allocates up to this minimum amount of
memory upon startup. Instead, SQL Server allocates memory only as it is required and may or may not
reach the minimum server memory value specifi ed.

c03.indd 65c03.indd 65 7/30/2012 4:10:08 PM7/30/2012 4:10:08 PM


http://www.it-ebooks.info
Free download pdf