Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Reference Architecture Guide—Ready Solutions for Microsoft SQL: Design for Dell EMC XtremIO
Executive summary Physical architecture Logical architecture Hardware and software components Design considerations Validation and use cases
Introduction
Infrastructure configuration
Dell EMC XtremIO X2
Data collection
OLTP use case
Peak CPU utilization
Average IOPS
Read and write latency
Storage latency
Combined performance of IOPS and latency
Database consolidation
XtremIO X2 inline data reduction
Conclusion References Appendix A: Best practice guidance Appendix B: Configuring vSphere Appendix C: Creating and mapping storage to the VM

Read and write latency

Read and write latency

  • 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.