Edit: This question is not related to SQL Server but perhaps to storage... but please let me ask it.
I am thinking of using a server which has 12 15K RPM drives.
By doing some googling, I have done the following arithmetic
One 15K RPM drive gives me on an average 200 IOPS
So 12 such disks should give me 2400 IOPS.
In my testing when I look at the sum of SQL reads / sec and writes / sec this value is pretty less than 2400. So I should be good with my new server.
My question is that will I really get 2400 IOPS or things like SATA controller should also be considered in determining IOPS of a server .... if so.... how?
View Complete Post