What are the merits of buying SAS drives over SATA drives, or vice versa?
SAS=SCSI=manageability, especially under load and also better prefailure diagnostics and tuning capability. Spendy and low capacity/£$€.
SATA=value, capacity and adequate performance for many loads but be aware that 99%+ of SATA drives aren't designed to work 24/7/365 under duress. Also putting them under busy server workloads can dramatically affect their MTBF.
I'd recommend SATA for everything but server and top-end workstation work. You really can't beat SAS for DB work overall.
|show 1 more comment|
There are two separate parts to your question. Simplifying a bit, a disk consists of the hardware and the controller. Usually when people say "SAS" or "SATA" they are referring to the controller. In principle SAS is a more sophisticated protocol, though in practice for servers with up to say 8 disks there probably isn't much difference between them.
Re the hardware: disk hardware tends to come in two classes based on the seek time. Fast disks have a seek time of 3 to 4 milliseconds while the slower disks have a seek time of 7 to 9 milliseconds. (I say "slower", but 7-9ms is still pretty fast!).
In general SAS controllers are fitted to fast disks while SATA controllers are fitted to slower disks, though there are exceptions. For example the Western Digital Velociraptor disks have a SATA controller but a 3ms seek time. So when people say "SAS disks" this is usually taken to mean "fast disks with a SAS controller" while "SATA" means "slower disks with a SATA controller".
All very well, but to actually answer your question, the seek time is very important when the disks have to do lots of random access. Good examples of this are SQL Server and Exchange. If the disks are a bottleneck then SAS disks will be a lot faster than SATA. However there are two points to make.
Firstly a good controller will make a lot of difference. I use Dells and I particularly like the Perc5/i and 6/i controllers. I have several 2950s with 6 SATA disks on a Perc5/i as a RAID 5, and these are pretty damn fast. Maybe they're not as fast as 6 SAS disks would be, but they're faster than say a 4 SCSI 320 disk RAID 5 on a Perc 4/e that I used to use in the older 2850 servers.
Secondly even though SATA disks are slower than SAS, in many small businesses disk speed won't be a bottleneck.
One last consideration is that traditionally SCSI disks have been (much) more reliable that SATA, not becuase of the controller, but simply because the disk hardware was built to a higher (and more expensive!) standard. Now that you have brands like the Western Digital RE3 SATA disks designed specifically for servers I'm not sure if this is still that much of an issue.
Here are some notes from Wikipedia on the topic (Serial attached SCSI):