Suitable disk subsystem for a high IO request - from MS SQL server.
Hi!
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.
Gabor
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.
Gabor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Example budget for a 2U server using DAS :
-SuperMicro SC216A with 24x hot swap 2.5" SAS/SATA drives : $1100
-MB dual socket 1366 with 18x DDR3 X8DAH+-F and 5x PCIe x8 : $480
-2x CPU Nehalem : E5520-2.26Ghz-80W $390 OR X5550-2.66Ghz-95W $1000 OR W5590 3.33GHz-130W $1690 = $2000 (2x X5550)
-18x DDR3 1333Mhz ECC Reg : 6x "3x4GB Wintec 3SR34550K-13" DDR3-1333 $400 = $2400
-3x Raid HBA LSI 9240-8i (8 internal ports no cache) + Cables : 3x $270 + Some cables = $1000
-1x Interconnect HBA : $1500 (dual 10Gbs or dual Infiniband 10Gbs)
-12x SSD Intel X25-M g2 160GB : 12x $400 = $4800
-12x SAS 15k 146GB : 12x $540 = $6480 OR 12x SAS 10k 300GB : 12x $300 = $3600
==> Results range from $17k to $22k per 2U server (no shipping no 24-7 service)
-Dual Nehalem CPU
-72GB
-1x RAID 10 array (8x SSD) 640GB redunded for highly intensively accessed data
-1x RAID 5 array (4x SSD) 480GB redunded for other data and temp
-1x RAID 10 array (8x SAS) 600GB redunded for Logs and Swaps
-1x RAID 5 array (4x SAS) 450GB redunded for Backup & WORM usage
-10Gb interconnection capability
-SuperMicro SC216A with 24x hot swap 2.5" SAS/SATA drives : $1100
-MB dual socket 1366 with 18x DDR3 X8DAH+-F and 5x PCIe x8 : $480
-2x CPU Nehalem : E5520-2.26Ghz-80W $390 OR X5550-2.66Ghz-95W $1000 OR W5590 3.33GHz-130W $1690 = $2000 (2x X5550)
-18x DDR3 1333Mhz ECC Reg : 6x "3x4GB Wintec 3SR34550K-13" DDR3-1333 $400 = $2400
-3x Raid HBA LSI 9240-8i (8 internal ports no cache) + Cables : 3x $270 + Some cables = $1000
-1x Interconnect HBA : $1500 (dual 10Gbs or dual Infiniband 10Gbs)
-12x SSD Intel X25-M g2 160GB : 12x $400 = $4800
-12x SAS 15k 146GB : 12x $540 = $6480 OR 12x SAS 10k 300GB : 12x $300 = $3600
==> Results range from $17k to $22k per 2U server (no shipping no 24-7 service)
-Dual Nehalem CPU
-72GB
-1x RAID 10 array (8x SSD) 640GB redunded for highly intensively accessed data
-1x RAID 5 array (4x SSD) 480GB redunded for other data and temp
-1x RAID 10 array (8x SAS) 600GB redunded for Logs and Swaps
-1x RAID 5 array (4x SAS) 450GB redunded for Backup & WORM usage
-10Gb interconnection capability
I recommend to PAQ the question::
-accepting BigSchmuh #28981202
-assisted by BigSchmuh #28988943 and andyalder #29011188
-accepting BigSchmuh #28981202
-assisted by BigSchmuh #28988943 and andyalder #29011188
ASKER
What about an update of the current storage EVA 4100 (e.g. to an EVA6100 or EVA8100)?