Sql Server Max Memory Decreased Automatically Stack Overflow
Here is the instruction how to set the memory, source technet In Object Explorer, rightclick a server and select Properties Click the Memory node Under Server Memory Options, enter the amount that you want for Minimum server memory and Maximum server memory Use the default settings to allow SQL Server to change its memory requirementsSQL Server Properties (Memory Tab) Use this tab to view or specify the following options Options Dynamically configure SQL Server memory Specify that Microsoft® SQL Server™ memory be configured immediately after you make changes to the server properties Use a fixed memory size Specify a fixed memory size for SQL Server
Sql server properties memory