Limit Memory Usage In SQL Server 2005

Posted about 7 years ago on October 08, 2007

Sometimes during development I see that the instance of sqlservr.exe is using > 500MB of memory. When this happens, performance for the rest of the apps running on my machine take a hit...so I needed a way to control how much memory sql server consumed. Turned out to be very easy:

1) Open SQL Server Management Studio, right click the server instance in object explorer:


2) Click on 'Memory' and change the min/max memory usage to your liking.

Comments

Anonymous writes...

Thanks! Simple.

April 16, 2008

Subhasis Chakraborty writes...

Thanks ....That was easy

Subhasis Chakraborty
Owner :- Collection Of Shayari

October 03, 2008

Anonymous writes...

thanks

December 19, 2008

Just A Guy With A Camera writes...

Thanks for blogging about this. I'm having trouble with a dev server trying to use too much RAM (the box only has 4 gigs and SQL Server is trying to use 2).

August 13, 2009

New Comment