Rob said:
I know, that old chestnut
We're currently running a five year old Dell
PowerEdge 4400 server with 5 x 70GB Hitachi Ultra 160 SCSI drives in
RAID-5 giving us ~280GB disk space. This server hosts our file share, SQL
7 and Exchange 5.5 services.
But the time has come to plan for the future and upgrade where
appropriate. We're looking at switching to Windows 2003 and buying another
server to host SQL Server and Exchange. We're at about 40 users at the
moment but have plans to grow to 100+
Simple question, complex answer I guess: is it still best to stick with
SCSI or consider SATA? I've read some positive reviews of the SATA Raptor
versus SCSI systems. Cost isn't really the biggest issue - mainly want the
best technology for the next five years. Yeah, I know - impossible task
You have to understand that for some people this is a religious issue. They
know with certainty on the basis of no information that one or the other is
"better".
In the real world it depends on your needs. If you need the highest
possible performance then SCSI is still the way to go--there is a wider
range of high performance SCSI hardware available, 15K RPM drives are
available from several vendors, there's a much wider range of hardware RAID
support available. You have to be careful in your system design
though--with SCSI it's possible for the SCSI bus to become the bottleneck.
If you need the highest _density_ then SATA has the edge--you can get 500 GB
SATA drives off the shelf now, today, from a number of sources while the
largest SCSI drive you can buy is only 300 GB. You can also get SATA
drives in 2-1/2" form factor from a number of vendors, while there's only
one manufacturer of 2-1/2" SCSI drives that I'm aware of. Manufacturers
tend to experiment a bit with SATA and IDE as well--the first perpendicular
recording drives for example just recently shipped and they are are IDE
laptop drives.
If you need the highest _availability_ on your system then things are not so
clear cut. Individually a SCSI drive will likely be somewhat more reliable
than an SATA drive. Collectively though, availability doesn't come from
the reliability of individual drives but from the reliability and
availability of the drive _system_. There, SATA has some advantages. The
big one is that it's not a shared interface--on a SCSI system if a drive
for example fails in such a way that it shorts one of the data lines to
ground it takes down the entire channel until it is removed. If you're not
running a mirror on another channel then your system goes down. SATA
doesn't have that problem--each drive is on a separate channel. There are
also several SATA RAID-6 solutions available--RAID 6 requires that _three_
drives fail before you lose data vs 2 for other RAID systems. This can be
implemented with SCSI drives in software under Linux but as far as I know
it's not available as a software solution under Windows as yet. So in
terms of system availability it's not clear that SCSI is the winner--what
will change is the frequency with which you have to replace failed drives
and I've seen no statistics on that that suggest that one or the other has
an edge.