Set a fixed amount of memory in SQL Server (Using SQL Server Management Studio)

Min Server memory and max server memory are two server memory options in SQL Server to configure the amount of memory (in megabytes) in the buffer pool used by an instance. SQL Server can change its memory requirements dynamically by default. But you can configure it based on your system memory.

Follow the following steps to set fixed amount of memory in SQL Server.

    1. Right click on server and select Properties in Object Explorer.

1

    1. Click/Select Memory node like below screen.

2

  1. Under Server Memory Options, enter the amount that you want forMinimum server memory and Maximum server memory. Here I used 4500 MB on basis of my system capacity.

Default settings:
Min server memory = 0
Max server memory = 2147483647 MB

Please share, if it is helpfulShare on FacebookShare on LinkedInTweet about this on TwitterShare on Google+Email this to someonePrint this page

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>