SQL Server Myth–Minimum server memory used on start up

When does the minimum server memory setting take effect?

image

There is a popular believe that when the SQL Server engine starts it will consume this mount of memory.  Not true!

On start up SQL Server will use whatever memory is required.  This may not meet the minimum memory setting.  Once the database load reaches or exceeds the minimum server memory setting, SQL Server keep the minimum server memory and not release it back to the operating system.

In the case above, the memory is set to 512MB.  However, SQL Server used less than that on start up.

image

 

Read more about this under the “Setting the memory options manually”” section in this TechNet article: http://technet.microsoft.com/en-us/library/ms178067.aspx

Advertisements
This entry was posted in Database Administration and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s