🚀 go-pugleaf

Sander,

try asking this question on one of the SQL Server newsgroups.
It's forever being debated on the Oracle newsgroups.
Majority *appears* to be against using Raid 5

You did not mention a hardware RAID controller. (definitely the way to go)
We decided to go with a 3-channel DPT Century RAID controller.
I hear the Compaq 3200? is also a decent choice (given you have Compaq).

We went with the following 7 drive config (again, this may not be best for
you)

Drive 1 - Hot Spare
Drive 2&3 - Raid 1 - OS, Page File, Apps/Binaries, Redolog set1
Drive 4&5 - Raid 1 -  Data, Temps,  Redolog Set 2
Drive 6&7 - Raid 1 - Indexes, Rollbacks

the above is for an Oracle install. Similar files exist in SQL Server.


Good luck,


Yev




Sander Eek wrote in message <81hcc9$46o$1@news1.xs4all.nl>...
>Hello,
>
>I am looking for some input on the following discussion:
>
>Situation: Compaq Proliant 1500 server, Compaq Storage System, 6 harddisks
>of 9 GB. Operating System Windows NT 4 Server - Systems Management Server
>2 - SQL Server 7.
>
>Purposed Configuration Solution 1:
>2 disks in Raid-1 for the system partition
>4 disk in Raid-5 for the SMS/SQL and data partition
>
>Purposed Configuration Solution 2:
>6 disks in Raid 5 as one logical disk.
>
>I am looking for input on the advantages and disadvantegs of both purposed
>solutions.
>
>Please cc your reply to seek@xs4all.nl
>
>Thank you for your trouble.
>
>Sander Eek
>Consultant
>
>