Home Page › Forums › BizTalk 2004 – BizTalk 2010 › BizTalk / SQL Server Issue › Re: BizTalk / SQL Server Issue
December 12, 2006 at 2:11 AM
#16847
You are right, SQL Server does play well with others. It is reluctant to release memory once allocated.
There are options in SQL Server where you can limit the maximum memory it will use. By default this is all the memory in the system.
You could try to limit SQL to 1GB of memory. This may slow SQL somewhat (smaller cache = more disk hits) but may speed up the machine as a whole by allowing other processes more memory and reducing page faults.