Hi I have been thinking of replacing our san that has 50 15k disks with either a ssd card like fusionio (http://www.fusionio.com) and ramsan (http://www.ramsan.com/) or, with 8-12 mid level ssds like intels x25-e http://www.intel.com/design/flash/nand/extreme/index.htm and use a good raid-controller in the server. And then use mirroring along with regular backup to protect us from data loss if the single ssd card or the x25-e raid would fail. Anyone here that have tried any of this? What are the results?
I don't know any one implemented in production but there many tests around on this... http://blogs.mssqltips.com/blogs/chadboyd/archive/2008/03/16/ssd-and-sql-sqlio-performance.aspx http://www.slideshare.net/markginnebaugh/fusionio-ssd-and-sql-server-2008