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