How to Limit SQL Server 2012 Memory Usage

We can set mininum and maximum amount of RAM that can be used by SQL Server.

For SQL Server 2008 R2 Or SQL Server 2012 minimum value is

• 32-bit OS: 64 MB 
• 64-bit OS: 128 MB

Please follow below steps to set Memmory options.

Step 1: Open SSMS.

Step 2: Connect to server.

Step 3: Right Click on Server Name go to properties.

Step 4: Go to Memeory Tab, Here you will get option to set Max and Min values for RAM.