How to configure memory options using SQL Server Management Studio

Hi, today I will share about setting Memory Consume in SQL Server. This feature is one of advantages using MSSQL.

You can change Minimum and Maximum memory without restart the services.

  1. In Object Explorer, right-click a server and select Properties.
  2. Click the Memory node.
  3. Under Server Memory Options, enter the same amount that you want for Minimum server memory and Maximum server memory.