Home Page › Forums › BizTalk 2004 – BizTalk 2010 › SQL Server running out of memory after some time › Re: SQL Server running out of memory after some time
May 14, 2009 at 2:04 AM
#22369
SQL Server is a memory hog and doesn’t play nice with others. It will continue to use memory if it is available and never gives it back.
You can put limits on the amount memory the SQL Server will use. This is good idea if you share your server with other applications which may also like to use memory.
http://msdn.microsoft.com/en-us/library/ms178067.aspx