We are looking at new servers. Today our SQL Servers are built as follows:
- C/D on RAID 1 ,
- E : Tempdb on RAID 1,
- F:log files on RAID 1 ,
- G : Catalog data on RAID 1 ,
- H: model data on RAID 1 ,
- I : symbols on RAID 1,
- J: DB maintenance on RAID 1 ,
So we have a lot of SSD’s, all on RAID 1 with no sharing.
We are considering changing to a large RAID 1+0. However the concern is if we will end up with performance impacts since there are random reads that happen throughout the day but not as much as writes.
My question is - whether a large 1+0 RAID is suggested / recommended, which would reduce the quantity of SSD’s that we use and allow us to expand a single container easier or stick with single RAID 1’s?