I'm planning to start a EC2 high memory instance with SQL server on it. I'm working through how to setup the drives as the current dedicated hardware is set to a raid-5 but only 4gb of ram so a lot of IO right now. With the high memory I am basically quadrupling the amount of memory and half the database would be in memory, so I am not worried about I/O limits.
What I am worried about is cloud drive performance, current plan is as such, Raid 5 three Local ephemeral drives for tempdb,transaction logs Raid 5 three EBS volumes for data
Nightly full backups of the database and transaction log will occur. My only question is, is this the best way to setup an EC2 SQL instance, and since everything is software raid, only Raid-5 is supported, is there a way to get Raid-10? Also what happens with an EBS or ephemeral drives dies, does the software raid(dynamic disk) kick in a spare or do I have to do that?