I've built a server using two raids - one with SAS drives and the other with SSD drives where the SQL DB resides.
My questions is whether RAID5 on SSD for Samsung 840 Pro drives is enough. I have recently researched more into this and they suggest to have a hot spare in this case but my server doesn't have any space left so that's out of the question.
What would be better option? Leave it as RAID5 or move to RAID 6 or RAID1+0?
Reading speed is very important as it's SQL server but security of the data is essential.
I run ShadowProtect to a SAN every 15 minutes on Dell PE R710
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.