HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
ProLiant Servers (ML,DL,SL)
cancel
Showing results for 
Search instead for 
Did you mean: 

MSA 500 disk performance analysis

 
Rui Vilao
Regular Advisor

MSA 500 disk performance analysis

Greetings,

I have a read intensive Oracle 9i database running on a 4 CPU Proliant. The data is stored on MSA 500 (G1) storage with 2x256MB cache and two SCSI 36GB 10K U320 drives configured in Raid 0+1.
CPU is always around 10-15%…
Database reports are terribly slow.

From Oracle Entreprise Manager I can see that most of the Wait Events are IO related…

I have checked that the MSA 500 controllers are limited to 160 MBytes/sec while MSA 500 G2 controllers
Since it is difficult to modify the database code I want to prove that a disk upgrade MSA 500 G2 controllers can cope with 380MB/sec and has 15K disks...
However I want to prove that the a faster storage will improve the application…

From Windows performance monitor I can see that the peak of Disk Read+Write (physical disk counters is around 30MBytes/sec which is far below the theoretical 160 MBytes/sec…

On the other side the current disk queue is around 18… This means there is always data waiting to be read/written…

Any help/suggestion is highly appreciated.

Thanks in advance for your help,

Kind Regards,

Rui.
"We should never stop learning"_________ rui.vilao@rocketmail.com
5 REPLIES
Ryan Goff
Valued Contributor

Re: MSA 500 disk performance analysis

what array controller is your MSA attached to?
Rui Vilao
Regular Advisor

Re: MSA 500 disk performance analysis

Hi Ryan,

It's a Smart Array 532 controller.
I really wonder where the bottleneck is:
- controller of MSA
- Smart Array 532 controller
- SCSI 36GB 10K U320 drives

TIA,

Rui.
"We should never stop learning"_________ rui.vilao@rocketmail.com
NiCK_76
Respected Contributor

Re: MSA 500 disk performance analysis

Hi Rui,

According to my experience Array controller or backplane should be bottleneck.


NiCK
just for fun
Ryan Goff
Valued Contributor

Re: MSA 500 disk performance analysis

The 532 controller has no write cache so that will slow down your performance quite a bit. You cannot add cache to this controller either. I'd suggest upgrading your controller to either of the following:

HP Smart Array 5302/128 Controller 283552-B21
HP Smart Array 5304/256 Controller 283551-B21
Smart Array 6402/128 Controller 273915-B21
Smart Array 6404/256 Controller 273914-B21

You might also want to check out this whitepaper:
ftp://ftp.compaq.com/pub/supportinformation/papers/tc020202tb_rev0_us.pdf
Stephen Kebbell
Honored Contributor

Re: MSA 500 disk performance analysis

Hi,

the MSA500 has its own write cache on the controller, and I'm not sure if those other controllers are supported with the MSA500.
Are you using Windows 2003? Have you enabled advanced performance for the disk devices in device manager (Disk Drives -> MSA volume -> Properties -> Policies)?

Regards,
Stephen