Mahedee Hasan

Mahedee Hasan

I am a Microsoft MVP (9th times), programmer, software developer, software architect, consultant, author, researcher, technical blogger, technical speaker, trainer and learner. I have more than 15 years experience in the field of software design and development.

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

less than 1 minute read

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.

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

  • Click/Select Memory node like below screen.

  • 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

You May Also Enjoy