RE: To use SAME or NOT for High End Storage Setup ? .... Stripe Unit Size 32 MB Vs. 64 KB ?
- From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 May 2006 07:24:19 -0700 (PDT)
In a similar setup (but with only 4 LUNs) with I had tested different stripe
sizes and found 8MB stripe size give the best performance. I had tested 1MB,
2MB, 4 MB, 8 MB, 16 MB stripe sizes.
regards
joseph
VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx> wrote:
Folks
1) IBM is recommending SAME (Stripe across all the 46 LUNs) + 2 separate LUNs
for online redo logfiles
2) IBM is recommending 32 MB Stripe Unit size across the 46 LUNs using Volume
Manager.
NOTE â?? Each underlying LUN has 8 Disks (Hardware Raid 1+0 with Stripe Unit
Size 64 KB â?? This is NOT changeable)
Qs. Any feedback on impact of 32 MB Stripe Unit Size(across LUNs) on
Performance of OLTP / Batch Transactions?
For now we are also considering doing a Comparative benchmark of Performance
of 32 MB versus 64 KB Stripe Unit sizes across the 46 LUNs.
NOTE â?? We may NOT be able to do an exhaustive comparison. Hence any similar
experiences would help very much.
NOTE â?? In a previous VERY Small benchmark on a few CPUs machine & a Very
Small Storage Box having just a Few Disks with single Software Striping(NO
Hardware Striping) , Performance of our Applicationâ??s Batch Runs was VERY
POOR for Stripe Unit Sizes of 512 KB, 1 MB, 2 MB. Performance was Good for
Stripe unit Sizes of 64 KB & 128 KB.
Layout:-
DB Server connects to -> 16 FC Controllers -> SAN Switch -> 18 FC controllers
-> DS8300 Storage Box
Filesystem = JFS2
1 DB Server - P595 model - 64 CPUs
2 APP Server - P595 model â?? Each having 64 CPUs
NOTE â?? At a time Only 1 of OLTP or bath runs will happen
Thanks indeed
---------------------------------
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of VIVEK_SHARMA
Sent: Thursday, May 11, 2006 6:58 AM
To: kevinc@xxxxxxxxxxxxx; Oracle-L
Subject: RE: To use SAME or NOT for High End Storage Setup ?
Kevin, Folks
For a DS8300 High End Storage:-
Which one of the following 2 is advisable:-
Qs. 1 Should ALL of the 47 (Hardware RAID 1+0) LUNs be Added into a Single
Volume using Volume Manager (RAID 1 â?? Striping) - SAME concept?
Qs. 2 Optionally should some â??Optimal Num / setsâ?? of these (RAID 1+0)
LUNs be added / assimilated into different (multiple) Volumes (of RAID 1 â??
Striping)? If so, What should be this Optimal Num of LUNs per Volume (4,6 or 8
LUNs) ?
NOTE â?? Database will be Laid out across all the 47 underlying LUNs
Qs. 3 Being an OLTP type Banking application 64 KB Stripe Unit Size is being
considered for Both of the following 2:-
i) The underlying Hardware RAID1+0 for LUN creation
ii) Also for the Volume Creation using Volume Manager (RAID 1 â?? Striping)
Would folks advise using different Stripe Unit Size for the above (i) & ii)?
Thanks indeed
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Other related posts:
