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.
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 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.
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.
Subscribe to:
Post Comments (Atom)
1 comment:
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).
Post a Comment