Database Server RAID Setup

[Manu]

Hey everyone, I am purchasing a new DB server for a disk intensive/cpu heavy database. My main questions are with the storage controllers and RAID setup.

This is my current thought:

RAID 0/1 36GB 15K SAS - OS and programs
RAID 0/1 72GB 15K SAS - main data
RAID 10 72GB 15K SAS - trans table (main table, most IO) from DB

What are your thoughts? Should I be looking at a dedicated controller for the RAID 10 and put the other RAIDs on a different one?

Any suggestions or recommendations would be very helpful.

Thanks,
Manu

 

[MorfiusX]

Which DB Server? (MS SQL, MySQL, Oracle, etc) What size DBs? How many transactions per day?

 

[JayAre]

When buying your server take a close look at which riser card and which back plane card you buy. It could impact the speed as well.

 

[Manu]

We're going to be upgrading from SQL 2000 to SQL 2005. The DB is actually really small, about 3.5GB, but it is a very poorly organized DB that tosses almost all data into a single table...