If you have 12 disks to hold DB Data files and decide to use RAID10, would you create 1 RAID 10 group or 2 RAID 10 groups made of 6 disks each for best read/write performance?

Published On: 2011-05-30 By: Denny Cherry

I would probably make 2 RAID 10 RAID groups one for the data files, and one for the transaction log. Without knowing what percentage of data access will be read and what will be write I’m just guessing here. Depending on the load RAID 5 may work just fine for the data files.

Denny

Contact the Author | Contact DCAC

Watch our most recent webcast

Register for our webcast on Friday November 15th, 2019 at 2pm Eastern / 11am Pacific where Meagan Longoria and Kerry Tyler will present their webcast “Is it time for an SSIS checkup?”.

Next Webcast

Watch our webcast on Friday October 18th, 2019 at 2pm Eastern / 11am Pacific where Denny, Monica and John will tell you everything you need to know about the PASS Summit including where to eat, where to drink, and where the parties will be.

Watch Now

See All Our Live and Recorded Wedbcasts

Social Icons

Contact Us

Site Title