We were having some disk drive performance issues at a client recently. They have a 6 drive array running RAID 10. We spent some time running SQLIO against the array. Our standard test was an 8KB random read with a queue depth of eight. The array was giving us 370 I/O operations per second with a latency of 42 ms. We cracked open the case and discovered it was using 7200 RPM SATA drives. We replaced the controller with the same model except that it was designed for SAS (serially attached SCSI) and installed six 15,000 RPM SAS drives. Running the identical test now resulted in 1,980 I/O operations per second with a 7 ms latency. Nice!
This is a companion discussion topic for the original entry at http://billg.sqlteam.com/2007/04/27/upgrading-to-sas-drives/