All good suggestions. Note: DO NOT add more that 3.5GB on a 32-bit system.
While the processor (and motherboard) can accept up to 4GB, the OS and video
interfaces often capture the top 500mb. If you add RAM that encroaches on
this space it will either be ignored (best case) or will cause conflicts
when the video card needs more headroom--this results in... well, bad stuff.
More RAM is key. All of my systems run at least 4GB (but all are now
64-bit). If you don't have enough RAM for the processes loaded, the system
has to swap. Swapping will kill performance. If you're running Vista, be
sure to insert a FAST USB key in the system so the system can use it as fast
swap space (ReadyBoost). This also seem to help. Yes, getting SQL Server
installed on a separate system also helps. But this is also true for IIS and
other overhead services.
hth
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com http://betav.com/blog/billva
____________________________________________________________________________________________