March 24, 2011 at 5:35 am
We are installing a new SQL 2005 64 bit machine and have 12 x300GB available. Given that what would be the best RAID config? I was thinking of
OS RAID 1
SQL Binaries/Tempdb RAID 1
SQL Backups RAID 1
SQL Logs RAID 1
SQL Data 4 disk RAID 10 or:-
OS RAID 1
SQL Binaries/Backups/Tempdb RAID 1
SQL Logs 4 disk RAID 10
SQL Data 4 disk RAID 10
Would there be any gain in having a 6 disk RAID 10 for data files and then trying to consolidate the other drives. Might be difficult as really want to isolate data, logs and backups.
March 24, 2011 at 8:23 am
i played with RAID 10 a few years ago. no scientific testing, but the performance didn't wow me. and the department that owned that server got sick of constantly buying more hard drives.
RAID 5 is OK in most scenarios. on one server i have a bunch of RAID 5 volumes to minimize the the io on each disk
my dream is to set up a SQL server with multiple RAID 1 volumes for data and log files to really optimize things. still waiting for the blank check for that one
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply