The short answer is RAID 1 is more redundant, and SSDs will be faster, but the next performance bottleneck is the RAID card itself.

The higher end the RAID card, the more internal RAM it will have, the more processing power, and the more that the performance of the SSDs will shine through.

All that said, the more users that you have, the more that the SQL version you have will installed will bear on the overall performance at production load.


Indy
"Boss"

Indy's Blog

www.BestForYourPractice.com
Our Name is Our Creed