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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of VIVEK_SHARMA
Sent: Thursday, May 11, 2006 6:58 AM
To: kevinc@polyserve.com; 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***