it really depends on the profile of your DB? If is used for OLTP and teh SAN
has enough cache then maybe raid 5 would be OK for you. It is cheaper (fewer
physical disks) but has a write performance penalty. this is no big deal if
you are doing lots of small writes. If the DB is more of a DSS(DW) then the
big queries, and summaries will result inlarge writes and the SAN cache will
be filled quickly dropping you back to physical write speeds. In that
environment, I would prefer RAID 10. If you have the cash, then I personally
like the SAME approach (Stripe And Mirror Everything) Ssimple! and
Effective!
I"d love to know what you decide. We are about to implement an EMC SAN here
and we have a 250Gb DW / OLTP. (don't ask)
Russell
On 8/11/05, Goulet, Dick <DGoulet_at_vicr.com> wrote:
>
> Yeah, Yeah I know it sounds like bug spray, but is there anyone out
> there who has placed a database on an EMC CX500 SAN using raid 10? If
> so, what was the performance like? Our EMC rep is trying to sell us on
> the idea.
>
> Dick Goulet
> Senior Oracle DBA
> Oracle Certified DBA
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 11 2005 - 00:11:31 CDT
