This blog is moved to

Thursday, March 5, 2009

Limit Memory Usage In SQL Server 2005

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 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.

1 comment:

Plankton Hijau said...

I've done what you mentioned. Set the max memory to 512 MB then shut down and re-run db. But it still occupied more than 512 (currently it sucked 841 MB).