[FlyBoy73]

Originally Posted by Erwin

If you had to choose between the following for a VERY BUSY DATABASE SERVER, which would you choose?

1. 10k Raptor SATA vs 10k SCSI?

10k SCSI or especially (SAS) Serial Attached SCSI without a second thought

2. 10k Raptor SATA (2) RAID 1 vs 10k SCSI?

Not exactly fair unless you are talking just raw speed. I look at RAID more for redundancy but as you add drives you will pick up performance boosts, especially in reads. I would still opt for 10k SCSI

3. 10k Raptor SATA (4) RAID 1 vs 10k SCSI?

Your tempting me now since you have 4 drives.. How good is your RAID card?

I'm trying to decide how essential SCSI is for a busy db server.

If you now take the 10k SCSI drives and add a good RAID card you will likely have a great database server.. Very fast if running RAID 10 or even a lot of drives in RAID 5 and full redundancy.

Also, choose between the following:

4. Dual Processor/ Dual Core Opteron 2.0 4 Gb with 10k Raptor SATA (2) RAID 0 (or RAID 1)

vs

Dual Xeon 2.8 (single cores) 3 Gb with 10k SCSI (no Raid)

for a busy database server???

Is SCSI so much better that it overrides the CPU advantage? Does RAID makes SATA better than SCSI?

Doc, with all due respect you are asking for trade-offs (IMO) on each this vs. that setup. I mean, if you asked me if I would go with the 10 SCSI (no Raid) with ether a Xeon or Opterson vs. a 10k Raptor SATA RAID 0 setup utilizing a Xeon or Opteron processor it would be easier to decide on but when I look at this my opinion is you handicap your setups. It's like good processor with ok drive setup or ok processor with a good drive setup.

I am no hardware guru but before I just dropped $6,470.00 on a server I studied this stuff pretty hard. I went back and forth with multiple server setups to single power-houses.. I looked at SATA Raptor 10k drives, SATA RAID controllers, SCSI u320 10k & 15k drives and finally learned about SAS 10k & 15k Cheetah, Atlas and other drives.

In the final analysis and my conclusion after reading for literally days on the subject is this: In a database server environment SCSI simply beats all SATA drives on the market today, including the Raptors (which I dearly love for my home PC and would use in a web server), especially when you get into RAID configurations..

And speaking of RAID setups... I studied this and asked everyone under the sun on which is the best... And for a screaming fast database server, the consensus seems to be RAID 10.

Your forums are undeniably large any way you look at them.. Personally, I would not even consider a SATA setup for your databases. You need a good RAID 10 or maybe a 5 setup with a lot of drives for your database server, IMO.

Here are the specifications of the server that I just purchased. It was designed to handle both our web & database needs for the emmediate future. When we need more I will add web sever(s) and transition this server to handle only database usage. When that time comes I will feel comfortable having single or dual opteron 1u server(s) that run a RAID-1 using (2) Raptor drives. Until then, I think it will be plenty.

One thing of note with regards to my server and pricing. It would have been a good deal cheaper if I had not gone with the SAS drives and the RAID card spec'd. I had a really nice RAID 10 setup with (4) 15k Cheetah drives for a little bit over $4,000.00 and would have been an awesome database server. I had plans to use that and also a web server but decided it would be more practical to just build a "monster" to handle our needs for now and save me hosting expenses at this point in time.

Spec's:
2x AMD Opteron 270 Dual-Core socket 940 CPUs (4 cores total)
Supermicro H8DAE dual socket 940 server board
8G DDR-400 PC-3200 ECC Registered, NUMA
Adaptec 4800SAS 8-port hardware SAS RAID controller, 133mhz PCI-X
2x Maxtor Atlas 73-Gig SAS, 15k rpm (RAID-1 for OS)
4x Maxtor Atlas 36-Gig SAS, 15k rpm (RAID-10 for data)
1x Seagate Barracuda 300-Gig IDE, 7200rpm (for backup)
on-board broadcom dual gigabit NICs
Supermicro IPMI 2.0 adapter (AOC-1UIPMI-B)
on-board ATI rage Video, 8M
24x slim CD-ROM; 1.44M Floppy
SuperMicro SC822T-R500RC 2U Rack-mount Chassis
6x Hot-swap HDD Carriers & 1x6 SATA/SAS Backplane
dual SuperMicro 500watt Redundant Power Supplies