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
Wednesday, January 20, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment