April 20, 2004 at 10:28 am
I have a question about the placement of the LDF and the MDF files for a MSSQL database. I am using SQL 7.0 and 2000 all with the latest service packs.
In a RAID 5 configuration it is my understanding that all drives behave as one with a parity stripe to keep track of where the data is (simplified I know). Now if the drives are partitioned into separate logical drives is there any real performance gain by putting the mdf on a different logical from the ldf?
The same question goes for a clustered environment where there are logical drives represent the clustered drives.
Thanks is advance for any responses.
April 21, 2004 at 3:25 am
If you have one RAID 5 array and divide that single array into two logical partitions, then no - there will be no performance gain for this type of partitioning. It's only a logical partitioning - it yields no more spindles or heads that can work in parallell as separate physical partitions do.
You would probably end up with less performance doing this.
/Kenneth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply