We are looking for a suitable disk subsystem, for an MS SQL server 2005. It works under the MS Dynamics AX ERP system.
The ERP team requested a huge IO rate: 8200 IOPS for random write.
The current disk subsystem, an HP EVA 4100 with 56 disks, seems to be not enough fast.
The average read response time = 5ms.
The average write response time = 70ms.
Details: DATA vdisk with 32x 15k disks in VRAID1, LOG vdisk with 8x 15k disks in VRAID1, TEMP vdisk with 16x 15k disks in VRAID1.
The DATA and LOG disks are dedicated disks, the TEMP disks are shared.
Which disk subsystem (storage) is able to handle such a huge write IO request?
Which one could you recommend us for a longer term - we are expecting fast-growing transaction number.