FATA disk or Fibre Channel drive? How do they compare in terms of performance and failure rates? Which is best for an Exchange 2007 and SQL infrastructure?
To understand whether a FATA disk or a Fibre Channel drive is the most appropriate drive type for Exchange 2007 and SQL, you need to know the performance characteristics of each drive type and that required by the applications. Fibre Channel and SATA drives have been around for a number of years, and their performance characteristics are fairly well-known -- Fibre Channel for performance and SATA for capacity -- but FATA drives are not as widely available and less is known about them.
Common sense would indicate that the “F” in FATA stands for “Fibre” and that the “ATA” stands for the standard “Advanced Technology Attachment”-type mechanism that is used in SATA drives.
Common sense in this case would prove correct, but does this mean performance is more like Fibre Channel than SATA, or more like SATA than Fibre Channel? In fact, a FATA drive is a little more than a SATA drive with an altered interface that allows it to be inserted into certain storage arrays without a separate enclosure. The underlying performance will therefore still be similar to that of a standard SATA drive and should not be considered for low-latency or intensive workloads.
Therefore, when considering S/FATA for an application such as Exchange or SQL, you need to understand the workload characteristics of the application. For a small SQL application, S/FATA may be entirely suitable; however, for more intensive workloads, Fibre Channel is the more appropriate choice.
Traditionally, Exchange has been an application that by default would sit on Fibre Channel hard disks. Even though Microsoft has reduced the disk performance requirements of Exchange 2007 and Exchange 2010 over previous versions, it is still important to understand the expected workload of the Exchange design, so you can select the most appropriate disk type and configuration.
Related Q&A from Steve Pinder
When adding an old hard drive to RAID sets on servers, it’s important to account for factors such as the number of drive bays in the host. See how to... Continue Reading
In this Ask the Expert, Steve Pinder talks about which RAID level to choose, depending on the criticality of your data or the capacity required. Continue Reading
Find out how RAID 5 handles sharing data shares data in a 10 MB file among five drives, including how striping and parity data figure into the ... Continue Reading