we are currently running SQL 2008 SP1 on a Windows Server 2003 Web Edition Server (2GB O/S RAM limit)
the issue is that SQL seems to be using a high disk I/O causing DB connections to be very slow and continual timeouts.
in perfmon the Avg. Disk Queue Length is always at 100 which is not good.
the server has 2GB ram due to O/S limitation which we understand is not the best. the RAID is a RAID1 with data & transaction logs on the same drive.
we are replacing this server but need to in the mean time wondering if there is anything we can do? I have changed SQL to us max 1.2GB RAM but the disk activity still peaks out.