RE: To use SAME or NOT for High End Storage Setup ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Thu, 11 May 2006 06:57:43 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF3020012195FE@BLRKECMSG11.ad.infosys.com>

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Closson
Sent: Wednesday, May 10, 2006 11:44 PM
To: Oracle-L
Subject: RE: To use SAME or NOT for High End Storage Setup ?

hmmm...is that much different than Shark? :-)

Anyway, while I don't fully understand the "2nd level of striping" question,

I can say from a lot of high end DS4X00 array testing that it

works fine. I routinely take sets of RAID1+0 LUNS and create

a volume in the volume manager as RAID1 (striped). Otherwise

you will have a bunch "chunks" (47 of them) and you'll have to

play some balance games to load up the spindles evenly. If

you put a filesystem on a striped volume of RAID1+0 LUNS you

are indeed SAME. Then you create tablespaces with datafiles

in the filesystem, use direct I/O, async I/O and you have the optimal

setup using decades old proven deployment methodology.

Or you could use ASM if you like RAW partitions.

PS. The DS4X00 arrays top their stripe width out at 256KB. I

generally go with that.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA

	Sent: Wednesday, May 10, 2006 10:46 AM
	To: Oracle-L
	Subject: To use SAME or NOT for High End Storage Setup ?

	Folks

	

	For a Big Benchmark should SAME (Stripe Across ALL Disks) setup

of a "DS8300" storage box be considered or NOT?

Storage has 47 LUNs

Each LUN has 8 Disks (Hardware RAID 1+0)

Qs. Should the 2nd Level of Striping be Done across ALL of the 47 LUNs (SAME) or some Optimal Num of LUNs?

Database will be spread out across these underlying 47 LUNs.

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*** -- http://www.freelists.org/webpage/oracle-l

Received on Wed May 10 2006 - 20:27:43 CDT