Configure SQL Memory Size

You can calculate the memory and usage from the link below

Recommended hardware - Configuration Managerdocsmsft

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.