I have installed SQL Server 2005 on our brand new Windows Server 2003 R2 Standard Edition server using all the default settings. I have WSUS installed and ISA 2004 which both use the SQL Server to store data.
I have noticed that 2 instances of sqlservr.exe are running when the system reboots, one as Administrator and one as SYSTEM. The SYSTEM instance is eating all the server memory resulting in Virtual Memory Minimum Too Low warnings. This results in the server failing and needing to reboot.
The system has 8GB of physical memory and I have set swap files of 4096 on C and 4096 on D Drives.
What do I need to do to control or limit this memory issue?
Many thanks in advance, NewAS.