I have recently ran some hard drive benchmarks on one of my servers follow Brent Ozar's blog. For the random writes test, i got 86.52 ios/sec and 2.23mbs/sec. I am not a hardware person, and my sys admin doesn't seem to know much about these stats as well. Are these numbers horrible? How do I figure that out?
closed as too localized by jcolebrand♦ Nov 19 '12 at 3:39
This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.
This pretty much depends on your I/O subsystem. I generally expect 100-120 IOPS per spindle on 7200 rpm S-ATA and 160-180 iops per spindle on 15k rpm SAS.
IOPS in this context typically refers to random 4K reads or writes, and I'm not entirely sure if the number you have given refer to physical 4k iops, or logical 8k iops.
Either way, 87 or 174 iops could both be within the expected range of a single drive, depending on type of drive and whether or not there were any other disk activity on the drive while running the benchmark.
As to whether these numbers are horrible, that ultimately depends on your requirements. I/O subsystems easily range from the 100 iops of a small webserver (single s-ata drive, or perhaps more commonly, two mirrored s-ata drives) to the 25,000 iops provided by the Oracle Database Appliance (20 SAS drives + 4 SSD drives) and beyond.