Configure SQL Memory Size
You can calculate the memory and usage from the link below
MEMCM recommends Memory for SQL:
Minimum - 8gb
Maximum - 80% of max system memory
Open SSMS
Connect to your SQL Server
Goto Properties for the server
Goto Memory
Set Minimum to 8gb (8192mb)
Set Maximum to 80% of system memory (I have 16gb / 16384mb in my system)
80% = 13107.2 mb
Once you click OK close SSMS and Reboot the Server.
Last updated
Was this helpful?