We’ve replaced our DS4500 and EMC systems with an IBM rebranded 3070 cluster. For the most part I’m very pleased with the performance but for a specific application the new system is about 15% slower then the old DS4500 was, even though it’s got more spindles at the same speed then originally.
 
Old system (DS4500) (15k FC)
8 disks in a RAID 5 array
10 in a RAID 10 array
2 more mirrored
 
New system (3070A) (15k FC) < This box is idling, the only stuff on it is this application (most stuff is on the other controller since I knew this app was a pain)
3 12 disk RAID groups in a single aggr (DP)
 
Should be 20 versus 30 spindles. I understand that there may be a slight impact from DP versus RAID0/10 for parity calculations, but I expected it to be more then absorbed by the 16x size cache on the Netapp, the extra spindles and the NVRAM for writes. So any suggestions on how to speed this up would be useful. I’m going to have the AIX guy re-run his tests tonight while I have statit running to capture how the disks are impacted but I think possibly the bottleneck is elsewhere.  Below are the test results from Sunday.

IBM SAN Stats (READ)

Benchmark Statistics for Database
DB Name: /vrback1/vrdata1/veeder        Proc Date: 10/05/08
Reading part master file
 
          Records Start    End      Duration
        ---------- -------- -------- --------
pt_mstr     52,674 12:50:30 12:50:52 00:00:22
reading customer master file
 
          Records Start    End      Duration
        ---------- -------- -------- --------
cm_mstr     17,984 12:50:52 12:51:14 00:00:22
reading order headers
 
          Records Start    End      Duration
        ---------- -------- -------- --------
so_mstr      4,213 12:51:20 12:51:28 00:00:08
reading order detail
 
          Records Start    End      Duration
        ---------- -------- -------- --------
sod_det     11,210 12:51:28 12:51:41 00:00:13
reading routing records
 
         Records Start    End      Duration
       ---------- -------- -------- --------
ro_det     87,514 12:51:52 12:52:13 00:00:21
reading address master file
 
          Records Start    End      Duration
        ---------- -------- -------- --------
ad_mstr    279,824 12:52:13 12:57:14 00:05:01
read install base records
 
           Records Start    End      Duration
         ---------- -------- -------- --------
isb_mstr    639,999 12:57:19 13:06:18 00:08:59
Read invoice detail file
 
           Records Start    End      Duration
         ---------- -------- -------- --------
idh_hist  4,573,493 13:06:18 13:57:25 00:51:07
 
 
NetAPPSAN Stats (READ)

Benchmark Statistics for Database
DB Name: /vrdata1_mr/veeder            Proc Date: 05/10/08
Reading pt_mstr
 
          Records Start    End      Duration
        ---------- -------- -------- --------
pt_mstr     52,674 12:43:08 12:43:43 00:00:35
reading customer master file
 
          Records Start    End      Duration
        ---------- -------- -------- --------
cm_mstr     17,984 12:43:43 12:44:12 00:00:29
reading order headers
 
          Records Start    End      Duration
        ---------- -------- -------- --------
so_mstr      4,213 12:44:19 12:44:35 00:00:16
reading order detail
 
          Records Start    End      Duration
        ---------- -------- -------- --------
sod_det     11,210 12:44:35 12:44:57 00:00:22
reading routing records
 
         Records Start    End      Duration
       ---------- -------- -------- --------
ro_det     87,514 12:45:00 12:45:27 00:00:27
reading address master file
 
          Records Start    End      Duration
        ---------- -------- -------- --------
ad_mstr    279,824 12:45:27 12:51:48 00:06:21
read install base records
 
           Records Start    End      Duration
         ---------- -------- -------- --------
isb_mstr    639,999 12:51:55 13:02:56 00:11:01
Read invoice detail file
 
           Records Start    End      Duration
         ---------- -------- -------- --------
idh_hist  4,573,493 13:02:56 13:47:13 00:44:17

 
IBM SAN Stats (Write)

R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,T
.wrote 100,000 records                          .
./spare3/qad86edb/bmark                         .
.          Start: 09:04:09                     .
.            End: 09:05:30                     .
.       Duration: 00:01:21                     .
F,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,G
 
NetAPPSAN Stats (Write)

R,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,T
.wrote 100,000 records                          .
./spare5_mr/bmark                               .
.          Start: 09:09:38                     .
.            End: 09:11:14                     .
.       Duration: 00:01:36                     .
F,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,G

 
This message (including any attachments) contains confidential
and/or proprietary information intended only for the addressee.  
Any unauthorized disclosure, copying, distribution or reliance on
the contents of this information is strictly prohibited and may
constitute a violation of law.  If you are not the intended
recipient, please notify the sender immediately by responding to
this e-mail, and delete the message from your system.  If you
have any questions about this e-mail please notify the sender
immediately.