Question

We got an new DELL MD1000 storage (with 15 SAS 15Krpm 146gb hds) for our database server.

What raid partitions can you suggest me?
We are think this:
2 disks in mirror raid for temp
3 disks in raid 5 for mirror-log
3 disks in raid 5 for log
7 diks in raid 10 for database files

Is an good setup? Does we need to change that?

Answer 1

It seems pretty solid. You may want to think about where the Windows paging file is going to go - its own RAID 1 perhaps.

There may be no point going for RAID 5 for the log files. Log files mainly get written to, where RAID 5 carries a penalty, you could just go for RAID 1 there as well. If the disk system is mirroring the log file, I'm not sure if its necessary to have a mirror log file as well, its another task the database server has to do - maybe someone else could comment on this?

If there are savings to be made on disks, you could allocate more disks to the RAID 10 for more stripes or just get more and faster RAM (assuming you are on 64-bit).