RAID System

What is the best RAID system to use in a SAN environment.
Is it ok to use RAID 5 on everything like data, log, etc
when using a SAN shared storage.In certain cases it may make sense to use other
configuration or use different raid levels for tempdb
(raid 0), log (raid 1+0), databases (raid 5) etc. Here you
have to be sure that you will be getting excellent
cooperation from the network/hardare support departments,
or if you are responsible for SAN and sql server.
Generally I would say it is ok to use raid 5 for
everything, because thats what I decided to use when we
configured SAN for sql server.
>--Original Message--
>What is the best RAID system to use in a SAN environment.
>Is it ok to use RAID 5 on everything like data, log, etc
>when using a SAN shared storage.
>.
>|||Every system has different requirements, but one is generally true - using
RAID 5 for logs is usually a bad idea because the parity calculation
requires additional overhead to read bits (disk i/o), parity calculation
(cpu, hba etc) & then the parity writes (more disk i/o).
Generally speaking, logs are far better off on a mirror, perhaps striped as
well, but not raid 5.
Regards,
Greg Linwood
SQL Server MVP
"Aboki" <waco361@.hotmail.com> wrote in message
news:13ac01c381e7$58753290$a401280a@.phx.gbl...
> What is the best RAID system to use in a SAN environment.
> Is it ok to use RAID 5 on everything like data, log, etc
> when using a SAN shared storage.