Earlier this week, EMC's Sam Marraccini wrote a guest blog on Microsoft's SQL Server team site highlighting the benefits of Flash technology with Microsoft SQL Server. In short, flash continues to be a game changer and with the introduction of EMC Xtrem products including XtremSF (PCIe server flash), XtremSW Cache (server side caching) and XtremIO (all Flash array) is helping to improve performance for key application workloads.
When using flash technology to either extend the cache of the storage array or using flash PCIe cards in the server itself (or even better, using both!) – you can dramatically increase the amount of total IOPS while also improving response times to sub-millisecond! Think about that, drive more I\O while significantly improving performance at the same time.