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
No...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:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx
-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.
sql
