Microsoft SQL Memory Leak work around. Microsoft SQL is a huge memory resource consumer there is no fix besides add more memory but there is a work around Microsoft provides
1.Log into the SQL Server using SQL Server Management Studio
2.Right click on the server go to properties
3.Click on the memory tab
4.Now the calculation is done in Megabytes 1024 MB is a gig
5.Subtract the system ram you want to leave free from your over all RAM.
6.I would leave at least 4 gigs of RAM free for the Operating System if possible.
7.The final answer is the number you type into the box that says “Maximum Server Memory (in MB)”