|
|
|
|
While reading through the documentation for the HP Storage Works 2000 MSA, I found the following performance numbers cited in the quickspecs for both the FC and SAS versions. The 2000fc version cited performance numbers for the fc (Fiber Channel), sa (SAS) and i (iSCSI) models. The 2000sa version only cites SAS results. The MSA 2000 Technical Cookbook also cites performance results.
The results cited in the FC model documentation for the SAS and iSCSI models cannot be correct, unless the SAS and iSCSI models were completely botched, and as far as I am aware of, it has been a really long time since HP/Compaq last botched a design this badly.
I am inclined to think that the results cited in the FC section are incorrect, and may inadvertently be used by HP sales rep to recommend the FC version. The configuration in the performance report below is somewhat ok for OLTP, 4 x 4Gbs FC ports or equivalent. Of course if I had 4 SAS RAID controllers, each connected to 2 MSA-60 with 12 15K HDDs, I could get 4-6GB/s sequential. For a clustered transaction processing system, you pretty much need the SAN to support shared disks. But I am inclined to ask people to consider database mirroring, each node employing direct attach storage.
For Data Warehouse applications, I would outright recommend the direct-attach MSA-60 and skip the SAN.
From HP StorageWorks 2000fc G2 Modular Smart Array on 2009 Sep 14
|
Performance numbers are a guideline as established by tests using RAW I/O in an Operating System Agnostic test lab environment. A total of 96 72GB 15K SAS drives were used in a dual controller configuration of eight 12 Disk vdisks, eight 806 GB volumes, and two volumes per host. Four hosts directly attached to the MSA2000fc G2 were used in this test configuration (results cannot be expected with a single host). Results were achieved in Sequential Writes with 256K blocks; all random tests were based on 8K block sizes. Number and type of applications, drive type, operating system used, and the number of hosts will affect overall performance.
|
| Workload |
MSA2300fc |
MSA2000sa |
MSA2000i |
| Host Connect |
4 Gb Fibre Channel |
3 Gb SAS |
1GbE Ethernet |
| |
|
|
|
| MSA2000 RAID 10 Performance Results (rounded) |
| Random Reads IOPs |
21,400 |
10,600 |
8,200 |
| Random Writes IOPs |
8,800 |
4,900 |
4,500 |
| Random Mix IOPs 60/40 read/write |
13,500 |
6,800 |
6,100 |
| Sequential Reads MB |
1,300 |
700 |
300 |
| Sequential Writes MBs |
560 |
350 |
260 |
| MSA2000 RAID 5 Performance Results (rounded) |
| Random Reads IOPs |
20,500 |
10,200 |
7,800 |
| Random Writes IOPs |
2,400 |
2,000 |
1,600 |
| Sequential Reads MBs |
1,300 |
700 |
300 |
| Sequential Writes MBs |
780 |
380 |
270 |
Random Mix IOPs 60/40 read/write |
5,900 |
3,300 |
3,200 |
| MSA2000 RAID 6 Performance Results (rounded) |
| Random Reads IOPs |
20,500 |
10,100 |
7,800 |
| Random Writes IOPs |
1,600 |
1,400 |
1,200 |
| Sequential Reads MBs |
1,300 |
700 |
300 |
| Sequential Writes MBs |
820 |
380 |
270 |
| Random Mix IOPs 60/40 read/write |
4,500 |
2,750 |
2,560 | |
From: HP StorageWorks 2000sa G2 Modular Smart Array
|
Performance numbers are a guideline as established by tests using RAW I/O in an Operating System Agnostic test lab environment. A total of 96 72GB 15K SAS drives were used in a dual controller configuration of eight 12 Disk vdisks, eight 806 GB volumes, and two volumes per host. Four hosts directly attached to the MSA2000sa G2 were used in this test configuration (results cannot be expected with a single host). Results were achieved in Sequential Writes with 256K blocks; all random test were based on 8K block sizes. Number and type of applications, drive type, operating system used, and the number of hosts will affect overall performance.
|
| Workload |
MSA2300sa G2 |
| Host Connect |
3Gb SAS |
| MSA2000 RAID 10 Performance Results (rounded) |
| Random Reads IOPs |
21861 |
| Random Writes IOPs |
14491 |
| Random Mix IOPs 60/40 read/write |
17700 |
| Sequential Reads MB |
1049 |
| Sequential Writes MBs |
531 |
| MSA2000 RAID 5 Performance Results (rounded) |
| Random Reads IOPs |
21019 |
| Random Writes IOPs |
2705 |
| Sequential Reads MBs |
1051 |
| Sequential Writes MBs |
644 |
Random Mix IOPs 60/40 read/write |
5897 |
| MSA2000 RAID 6 Performance Results (rounded) |
| Random Reads IOPs |
21029 |
| Random Writes IOPs |
1918 |
| Sequential Reads MBs |
1054 |
| Sequential Writes MBs |
736 |
| Random Mix IOPs 60/40 read/write |
4872 | |
The following slide is from the HP MSA2000 Technical Cook Book.

Update 2009 Oct 30
Apparently HP has updated the HP StorageWorks 2000fc G2 Modular Smart Array spec sheet
Performance numbers are a guideline as established by tests using RAW I/O in an Operating System Agnostic test lab environment. A total of 96 72GB 15K SAS drives were used in a dual controller configuration of eight 12 Disk vdisks, eight 806 GB volumes, and two volumes per host. Four hosts directly attached to the MSA2000fc G2 were used in this test configuration (results cannot be expected with a single host). Results were achieved in Sequential Writes with 256K blocks; all random tests were based on 8K block sizes. NOTE: Number and type of applications, drive type and number of drives, operating system used, and the number of hosts will affect overall performance. |
| MSA2 G2 Performance |
MSA2300fc G2 |
MSA2000sa G2 |
MSA2000i G2 |
| Protocol (host connect) |
4 Gb Fibre Channel |
3 Gb SAS |
1GbE Ethernet |
| MSA2000 RAID 10 Performance Results |
| Random Reads IOPs |
22,874 |
21,861 |
13,658 |
| Random Writes IOPs |
15,008 |
14,491 |
14,399 |
| Random Mix IOPs 60/40 read/write |
17,878 |
17,700 |
13,493 |
| Sequential Reads MB |
1,238 |
1,050 |
274 |
| Sequential Writes MBs |
532 |
532 |
266 |
| MSA2000 RAID 5 Performance Results |
| Random Reads IOPs |
22,044 |
21,000 |
12,335 |
| Random Writes IOPs |
2,714 |
2,714 |
2,714 |
| Random Mix IOPs 60/40 read/write |
5,325 |
4,926 |
5,325 |
| Sequential Reads MBs |
1,238 |
1,050 |
274 |
| Sequential Writes MBs |
725 |
617 |
266 |
| MSA2000 RAID 6 Performance Results |
| Random Reads IOPs |
21,975 |
21,000 |
12,292 |
| Random Writes IOPs |
1,876 |
1,876 |
1,876 |
| Random Mix IOPs 60/40 read/write |
4,293 |
3,865 |
3,851 |
| Sequential Reads MBs |
1,238 |
1,050 |
274 |
| Sequential Writes MBs |
772 |
729 |
266 |
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About jchang
Reverse engineering the SQL Server Cost Based Optimizer (Query Optimizer), NUMA System Architecture, performance tools developer - SQL ExecStats, mucking with the data distribution statistics histogram - decoding STATS_STREAM, Parallel Execution plans, microprocessors, SSD, HDD, SAN, storage performance, performance modeling and prediction, database architecture, SQL Server engine
|
|
|
|
|