When do I want to look at IOPs and when megs per second?

Question: When do I want to look at IOPs and when megs per second?

Answer: IOPs and Megs Per second are two very different numbers, and there are specific times when you want to look at each one. When dealing with sequential IO, which is typically generated by a data warehouse or reports being run that look at large amounts of data you want to monitor the counters which report the number of Megs Per Second.  When dealing with random IO, which is typically generated by OLTP databases, you want to monitor the number of IOPs that are being processed.

The reason for the difference is that when dealing with random IO you need to keep in mind that it takes time for the head to move from each place to the next that it needs to read or write.  The further apart that these blocks are on the physical disks are from each other the lower the number of IO that the disks can process per second.  While when dealing with sequential IO the blocks are right next to each other so you want to keep track of the amount of data that is being pushed down to the disks.  The number of IO being processed end up going through the roof as the blocks are next to each other, so when doing sequential IO monitoring the IO numbers isn't helpful instead you'll want to monitor the throughput in megabytes.

Denny