June 3, 2008 at 12:53 pm
I need to re-configure 4 SQL 2000 servers, we have 2 trays of disks where the sys admins configured a raid 0+1 array on the first tray and a raid 5 array on the second one, our budget at the moment is somewhat limited so I was thinking of placing all the log files of the 4 sql servers on 4 different partitions created on the 0+1 raid and all the data files on the corresponding partitions on the raid 5 disks.
The sys admins want to install the OSs on the same set of hard drives (same partitions actually) where the sql server log files will be, now I don't know if this is a best practice or should I be concerned about having OS files (i.e. windows paging file) along with SQL server log files?
Second question: Is it a good idea to place tempdb data and log files on the same partition as the rest of the sql log files?
Any comments are greatly appreciated.
June 3, 2008 at 1:13 pm
As long as the files are in the same raid, there is no difference in performance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply