IOPs is Overrated, yeah, I said it.
How many compute, storage area networks, hard drive vendors and storage services have posted their IOPs capabilities in marketing and didn’t include the throughput (MPBs)? Why when someone sends me IOPs for an Oracle database do I thank them kindly and ask for throughput?
Read on for more. This post is specific to Oracle but the general principle applies to SQL Server and all other relational databases as well.