SQL Server - Set a fixed amount of memory

Set a fixed amount of memory usage in SQL

1.      Open SQL Server Manager

2.      In Object Explorer, right-click a server and select Properties.

3.      Click the Memory node.

4.      Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory.

Use the default settings to allow SQL Server to 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 megabytes (MB). The minimum amount of memory you can specify for max server memory is 16 MB.

Source: http://technet.microsoft.com/en-us/library/ms191144(v=sql.105).aspx

Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.