DWH Hardware Configuration

We are currently in the process of looking into setting up a Data WareHouse
in SQL2000 so that we can use Cognos to report on the data.
I am looking at what hardware to run SQL2000 on just for the DWH. On all of
our other SQL2000 servers we have a very VERY simply hardware config of a
single RAID controller with 2 mirrored drives for the OS and then 3+ drives
in RAID5 for the SQL Data and Logs (on same logical drive).
Obviously, I want to make sure that I configure the new machine around a DWH
environment so was wondering if anyone had any suggestions of the best way
of doing this.
The hardware I am looking at is an IBM x255 a couple of 18Gb drive mirrored
for the OS and then seperate logical drives for the log and data.
Should I use seperate RAID controllers for the SQL data and log?
Is RAID 5 the best way to go with regards to the log and data?
Anything else I should be looking for?
Thanks.What are the requirements? How much data, how well is modeled, how will it
be accessed, how many concurrent queries and what types of queries? Any end
user access or just cube builds? Any ad-hoc access?
"Peter Shankland" <aopz10@.dsl.pipex.com> wrote in message
news:OUyPjwAwDHA.2448@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We are currently in the process of looking into setting up a Data

---

WareHouse

quote:

---

> in SQL2000 so that we can use Cognos to report on the data.
> I am looking at what hardware to run SQL2000 on just for the DWH. On all

---

of

quote:

---

> our other SQL2000 servers we have a very VERY simply hardware config of a
> single RAID controller with 2 mirrored drives for the OS and then 3+

---

drives

quote:

---

> in RAID5 for the SQL Data and Logs (on same logical drive).
> Obviously, I want to make sure that I configure the new machine around a

---

DWH

quote:

---

> environment so was wondering if anyone had any suggestions of the best way
> of doing this.
> The hardware I am looking at is an IBM x255 a couple of 18Gb drive

---

mirrored

quote:

---

> for the OS and then seperate logical drives for the log and data.
> Should I use seperate RAID controllers for the SQL data and log?
> Is RAID 5 the best way to go with regards to the log and data?
> Anything else I should be looking for?
> Thanks.
>

---