In this technical overview, we compare the number of requests per minute (NOPM), a throughput metric, with the average and 99.9 percentile latencies using standard online transaction processing (OLTP) performance metrics and a very large data set (too large to fit in an available system memory). Our results highlight the business impact of high-performance NVME SSDs in OLTP environments compared to SATA SSDs. NVME SSDs allow you to do more in less space.
Testing took place on a DELL Poweredge R750 server , we tested three storage configurations: two with NVMe solid-state drives and one with SATA solid-state drives as the base. Each configuration uses the same basic hardware (server, processors, and RAM):
We've found that NVMe SSDs generate 2.5x to 2.7x faster transaction speeds, which really benefits OLTP workloads on Microsoft® SQL Server.
NVMe configurations are responsive and stable, reducing average latency by 23-32% and 99.9th percentile latency by 88-89%.
Increased bandwidth, fewer disks Solid-state drives are the basis of high-performance IT systems with low latency. Ultra-high-performance NVMe SSDs, such as Micron's 9300 series, provide more capacity and speed for such systems, handling more data and delivering more benefits than two to four times more enterprise SATA SSDs. In OLTP systems, a higher NOPM can mean a higher number of orders entered and executed, resulting in greater value. The difference in NOPM between the Micron 9300 PRO-based platform and the platform with eight 1.92TB enterprise-class SATA solid-state drives is shown in Figure 1. The relative transaction speed for each configuration is shown during system boot, just before the test reached the halt state (see "How we tested" for details on the stop state). The NOPM values of NVMe configurations are extremely high. The 2x NVMe configuration achieved 1.5 times the NOPM of the baseline, and the 4x NVMe configuration achieved 1.7 times the NOPM.
Fast, consistent transaction response 2.7X 2.5X High transaction throughput (NOPM) is essential for many applications, while fast, consistent database response (latency) may be more important for time-sensitive applications. We measured and compared the average latency and the 99.9th percentile latency (a good measure of latency stability) when the system was under load just before the test reached a halt state (see How We Tested for details on the halt state) for three storage configurations . We used the same metrics, database and testing conditions.
NVMe SSDs show huge advantages in working with Microsoft SQL Server and OLTP workloads. Supporting much higher transaction speeds with lower and more consistent latency means more transactions are completed faster and more consistently.
How can we help?
For more detailed information about the DELL PowerEdge R760 server with DDR5 4800 or the DELL PowerEdge R750 server with DDR4 3200, you can visit our website SERVER SOLUTIONS , to find out the price of the server, go to the DELL Server Configurator link .