OLTP workloads are characterized predominately by small reads and writes to storage. A key indicator of storage performance for OLTP workloads is physical read and write latencies. The lower the latency the less time the database waits for reads and writes from storage. The gold standard for all-flash storage arrays is an average of 1 ms or less for all physical database operations. Modern storage arrays from Dell EMC have improved on the gold standard by accelerating storage operations, frequently achieving latencies of 0.75 ms or less.
In this guide, we review XtremIO X2 latency findings for SQL Server in microseconds, 1,000 of which equals 1 ms. The XtremIO X2 storage reports use microseconds as the measure for latencies.