July 25, 2002 at 2:24 pm
We are install new disks on our production server. Currently we have a raid 5 setup. We will be going to a raid 0 + 1. My concern is that the log files will be all on one disk. What performance issues will this change potential encounter?
Charlene
July 25, 2002 at 4:21 pm
Since the logs are sequential, it's nice to have them on their own disk so the heads don't move. Do you currently have data and logs (all databases) on a single RAID 5? What's the new setup?
My guess is that you are going to have 2 0+1 arrays, 1 for databases, 1 for logs.
HAving all the logs on one array is better than mixing the data and logs. The heads will still be moving, but they will be moving less than the other way. If it becomes a bottleneck, then add more disks and separate out the logs further.
Steve Jones
July 25, 2002 at 5:00 pm
I agree its better to separate the logs. Though to me its as much for the additional redundancy than anything. The theory behind the sequential writes to the log sounds good, but if you have a lot of logs I think it falls down. I have 200+ db's right now, putting the log for each on a separate drive...would be interesting!
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply