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 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.

NEXT WEBCAST

Watch our webcast from Friday September 6th, 2019 at 11am Eastern / 8am Pacific where Denny Cherry was joined by Kevin Kline of SentryOne and they took you through five surprising situations where what you don’t know WILL hurt you.

WATCH NOW

See All Our Live and Recorded Webcasts

Social Icons

Contact Us

Site Title