Home > DeveloperSection > Blogs > How to configuring SQL Server memory settings

How to configuring SQL Server memory settings


Database Database 
Ratings:
0 Comment(s)
 7076  View(s)
Rate this:

Server Memory Options (SQL Server 2008 R2)

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).

The following example sets the max server memory option to 4 GB:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'max server memory', 4096;

GO

RECONFIGURE;

GO


Don't want to miss updates? Please click the below button!

Follow MindStick