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.
- In Object Explorer, right-click a server and select Properties.
- Click the Memory node.
- Under Server Memory Options, enter the same amount that you want for Minimum server memory and Maximum server memory.