Brent Ozar (blog | twitter) recently made some comments about the FusionIO SSD drives. Basically, he was able to break three drives in a row – simply by doing load testing against them (using SQLIO). The symptom is simple: the drives go offline and disappear from the O/S, and need to be physically pulled from the machines. Kind of scary.
I am not trying to be Debbie Downer here … SSDs sound great, and my next MacBook will definitely come with one. I am sure they are not far from production excellence, and the I/O performance they offer — especially in shops like ours, where we are I/O-bound — will be world-shattering. But right now, if you are looking at expanding or upgrading your I/O under SQL Server, I'd give the vendors some time to shake off these early jitters. Hopefully they will come back with a quick fix or even an explanation that there was a misconfiguration of some kind … since I know others are already using these drives in production, and haven't come across similar issues.