Company had an aging 2012 sql server. No applications-- they are just using it for querying data and at any given time are working with ~10 DBs about of varying sizes 5gb to 500gb. They bought
SQL Server 2019 / Windows Server 2019 VM on Server 2019 Hyper-V host. HPE DL380 Gen10 with P408i-a > SAS expander > 2x8 cages. So 16 spots to work with. They've got 5x 1.9tb SATA SSDs and 10x SAS SSDs.
How would y'all configure the RAID? Given the two different interfaces, I believe they need to do at least two arrays. So I'm thinking
1. 2x SATA in RAID 1 for OS
2. 2x SATA in RAID 1
3. 1x SATA spare
4. RAID 1+0 for the SAS drives (says I'll end up with 8.7TiB)
Other options are Raid 10 (ADM) if I drop down to 9 SAS drives and it drops the size to 5.2TiB, but I'm not sure what the difference is there. Also RAID 60 is an option, and bumps the size to 10.4TiB. I haven't set up a SQL server since we were using spinning drives and it was supposedly better to have a separate array for tempdb / log / data.
I'm also not sure how the VM comes into play. I assume I'll set up a VHD at least for each logical drive I set up, possibly more if it is kosher to do so these days.