Too bad its not up to the challenge even on paper...
This is what we are trying to get:
2 Western Digital Caviar SE WD1600JS 160GB 7200 RPM Serial ATA II Hard Drive - OEM @ $81.00 - [link]
1 Athena Power AP-P4ATX50FE EPS12V 500W Power Supply 115/230 V - Retail @ $57.50 - [link]
2 CORSAIR 1GB 184-Pin DDR SDRAM DDR 400 (PC 3200) ECC Registered System Memory Model CM72SD1024RLP-3200 - Retail @ $135.00 - [link]
1 ASUS NCCH-DL Dual Socket 603/604 Intel 875P ATX Server Motherboard - Retail @ $225.99 - [link]
2 intel Xeon EM64T 3.0 Irwindale 800MHz FSB Socket 604 Processor Model BX80546KG3000FU - Retail @ $354.99 - [link]
1 CODEGEN 4U-500-CA Black Aluminum/Steel 4U Rackmount Case - Retail @ $80.00 - [link]
It will be interesting to see how well this performs with an online database considering the harddrives are slower than the ultra160 SCSI drives I have in my server. Plus the added factors of the onboard RAID controller, the lack of disconnected operation and transactional operation in SATA and the lack of a possibility of a performance enhancing configuration.
But, lets just look at the specs:
Drives currently in boris.kayfox.org:
ST-39102LW Ultra2 SCSI Wide (Cheetah 9LP, LVD)
AVERAGE ACCESS (ms read/write)____________5.4/6.2
SINGLE TRACK SEEK (ms read/write) ________0.8/1.1
MAX FULL SEEK (ms read/write) _________<__12.2/13.2
Model Number WD1600JS
Average Read Seek 8.9 ms (average)
Track-to-track Seek3 2.0 ms (average)
Full Stroke Read Seek3 21 ms (average)
Considering how old the drives in Boris are, I would think Jheryn would have considered this and located an Adaptec RAID 5 Ultra160 or Ultra320 controller and some inexpensive 50GB or 73GB drives to put in an array, which out fo the box and without any software tweaking would be faster, but not cheaper. This configuration would even be a speed improvement if the dual processors were swapped out for a single proc configuration, considering how much more a database will rely on disk speed rather than processor power.
And yes, I am posting this here because