Usually, processors are not critical, although they are important. A
dual PP200 should be fine for moderate to heavy loads,
> Speed of Hard Drive? Should I upgrade my single 10k RPM drive to a Raid0
> solution for speed (I'm using a second server as backup)?
The more spindles the better. As your Database grows, a single
harddrive will be a major bottle neck. You should look into hardware
RAID with atleast 3-4 drivers for better performance.
> Right now we are running SQL for Radius NT on a Pentium II 333 with 256M of
> RAM and a 9G IBM 10k RPM drive. I'm seeing a lot of write waiting and a
> bunch of I/O all at once (along with some weird CPU spikes). Wanted some
> expert opinion on Hardware before I started reviewing what I could do.
SQL Server loves RAM. The more the better. Thats probably #1 on my
list. Secondly is driver spindles, followed closely by CPU speed.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list, including removal, pleasesee this URL: http://www.iea-software.com/maillist.html