Ask for Recomendation

Dear All,
Pls take a look at the attached picture.
Drive E, F and G -> Raid 5
Drive C and D -> Simple Partition
My Question:
1. Where should to place the MDF dan LDF file?
2. Is it necessary to have multiple filegroup since I use RAID5?
Thanks
Robert LieIf you are heading for performance and not safety there is a simple rule
Raid 5 bad, Raid 10 good.
But now your stuck in, i would lay them on separate disk (There is not much
place there left, based on the value of the picture, and you didnt give any
db value,so you have to decide it.)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Robert Lie" <robert.lie24@.gmail.com> schrieb im Newsbeitrag
news:OBB%23J58SFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Pls take a look at the attached picture.
> Drive E, F and G -> Raid 5
> Drive C and D -> Simple Partition
> My Question:
> 1. Where should to place the MDF dan LDF file?
> 2. Is it necessary to have multiple filegroup since I use RAID5?
> Thanks
> Robert Lie
>|||Robert
If your goal is performance you should place.MDF and .LDF files on different
physical disk
As Jens has mentioned RAID-5 is 'bad' for writes and 'good' for reads. You
will have to determine whether your OLTP is heavily writing or reading and
then to make a decision
It would be good if you place your LOG file on mirrored disk array RAID-1&0
because the write activity tends to be sequential and is synchronous.
"Robert Lie" <robert.lie24@.gmail.com> wrote in message
news:OBB%23J58SFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Dear All,
> Pls take a look at the attached picture.
> Drive E, F and G -> Raid 5
> Drive C and D -> Simple Partition
> My Question:
> 1. Where should to place the MDF dan LDF file?
> 2. Is it necessary to have multiple filegroup since I use RAID5?
> Thanks
> Robert Lie
>