The high latencies and complexity of HDD and hybrid storage arrays can make it very difficult to get good performance from business-critical SQL Server databases. With real-world workloads from virtual database servers, I/O processes that might otherwise have been relatively sequential become an unpredictable blend of random I/O.
This report covers a set of compression tests and performance tests that quantify the benefits of Kaminario’s K2 All-Flash Array storage for Microsoft SQL Server.