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

Watch our webcast which was broadcast on April 1st, or April 2nd (depending on which part of the world you are in) as Kevin Kline and Denny Cherry talk about the Top 5 Considerations When Moving Databases to Azure.

Watch Now

Watch our Webcast from March 12th, 2020 where Denny Cherry will cover what steps a company should go through in advance of a Ransomware attack so that you are protected from an attack; what a Ransomware attacker can (and probably will) go after; and what you can do after the fact to bring your company back after a Ransomware attack, without paying the ransom.

Watch Now

See All Our Live and Recorded Wedbcasts

Social Icons

Contact Us

Site Title