You need to also consider depending on the controllers and storage infrastructure the number of IOPS you get can vary drastically. For instance I have a RAID 0 (not good for production) with 8 near line sata drives using a LSI 9280-e controller connected with dual mini SAS connectors to my external array. I can get 15,000 IOPS with this configuration. To get equivalent with a RAID 10 configuration you would need at least 16 drives. The LSI controller also performs some "magic" in that it's bundling up small sized IOs like Essbase uses (8 kb size) and making them much larger in order to gain maximum performance. Not all controllers will do this type of thing.
Testing with a tool like IOMETER to really understand the number of IOPS your specific configuration will deliver is best. Hands-down no amount of physical drives will give you more IOPS than PCI SSD technologies.
Regards,
John A. Booth
http://www.metavero.com
Scoring disabled. You must be logged in to score posts.