Friday, March 30, 2012

RAID5 for all files?

In the last few months I've run across two places that had all their
files, including both data and logs, on big, fat RAID5 partitions.
In fact, in one place even the OS and pagefile were on RAID5!
Is this, like, a good idea all of a sudden, and nobody told me?
I hautily informed them that putting in separate physical drives for a
RAID1 set for logs, might provide a load/scalability/performance
factor of 2x all by itself. Is it at all likely that this is actually
the case? Just wondering.
Thanks.
JoshNo...Raid 5 still sucks. The baarf web site is still in
operation - http://www.baarf.com/
Logs being separated out on a Raid 1 or Raid 10 is still
recommended - see the Storage Best Practices:
[url]http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx[
/url]
-Sue
On Sun, 05 Aug 2007 20:17:18 -0700, JXStern
<JXSternChangeX2R@.gte.net> wrote:

>In the last few months I've run across two places that had all their
>files, including both data and logs, on big, fat RAID5 partitions.
>In fact, in one place even the OS and pagefile were on RAID5!
>Is this, like, a good idea all of a sudden, and nobody told me?
>I hautily informed them that putting in separate physical drives for a
>RAID1 set for logs, might provide a load/scalability/performance
>factor of 2x all by itself. Is it at all likely that this is actually
>the case? Just wondering.
>Thanks.
>Josh|||As Sue mentions it is still not the best practice to use Raid5 for a busy
OLTP system.
Andrew J. Kelly SQL MVP
"JXStern" <JXSternChangeX2R@.gte.net> wrote in message
news:kd4db35ek3ge7ldau600i4tk7igv6irns6@.
4ax.com...
> In the last few months I've run across two places that had all their
> files, including both data and logs, on big, fat RAID5 partitions.
> In fact, in one place even the OS and pagefile were on RAID5!
> Is this, like, a good idea all of a sudden, and nobody told me?
> I hautily informed them that putting in separate physical drives for a
> RAID1 set for logs, might provide a load/scalability/performance
> factor of 2x all by itself. Is it at all likely that this is actually
> the case? Just wondering.
> Thanks.
> Josh
>|||On Mon, 6 Aug 2007 08:50:20 -0400, "Andrew J. Kelly"
<sqlmvpnooospam@.shadhawk.com> wrote:

>As Sue mentions it is still not the best practice to use Raid5 for a busy
>OLTP system.
And even less good for a busy ETL system building gigabyte tables and
output files?
J.

No comments:

Post a Comment