Wednesday, January 20, 2010

SQL Server the memory hog

So on my development machine, where I'm keeping everything local. SQL Server 2005 often uses up too much memory,(the other contender is VS) and it starts paging, and everything ends up in a crawl...
the quick and easy fix:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'max server memory', 4096;--Set this to some reasonable amount, like 1GB
GO
RECONFIGURE;
GO

It roughly caps the memory usage of SQL server.

The details:
http://msdn.microsoft.com/en-us/library/ms178067.aspx
http://msdn.microsoft.com/en-us/library/ms180797.aspx

No comments: