I'm considering moving a large database from mechanical disks to SSDs. My initial instinct was to go for RAID 10, but further research suggests that this configuration can significantly reduce the random access performance of the SSDs.
The database is very much read heavy and it's generally generating large data reports, so my assumption is that there is very little by way of sequential workload.
The main alternative suggested to RAID 10 when it comes to SSDs is RAID 1. Of course, this limits me to the size of a singe disk which is, realistically, going to be less than 1TB. This is not ideal.
I guess my question is, just how significant is the random access hit and, assuming I need greater capacity than a single drive can offer, what is a good alternative? Bear in mind this is a Server 2008 box so fancy ZFS solutions or the like are, sadly, not an option.