Home > Workload Solutions > SQL Server > White Papers > Dell EMC PowerMax Storage for Mission-Critical SQL Server Databases > Test case 1: Quality of Service (QoS) test
Test case 1 demonstrates exemplary Quality of Service (QoS) for a demanding SQL Server database running an OLTP workload on the PowerMax.
We ran a single SQL Server database OLTP workload with a SQL Server buffer pool size of 4 GB. TheSQL Server database was set to the Diamond service level. While the test ran, we monitored host IOPS, SQL Server Transactions Per Minute (TPM), and read and write response times.
As the test results in the following figure show, the SQL Server database at the Diamond service level serviced by SCM drives coupled with the PowerMax cache provided very high performance at unrivaled low latencies.
Figure 7. QoS Test for single SQL Server database
The test produced an unprecedented read response time of 0.17 ms and a write response time of 0.16 ms. All components of the storage system were still well balanced and capable of supporting other workloads. Due to the very low response times, SQL Server database on PowerMax allowed for host IOPS of 250 K with a SQL server database OLTP TPM of 2.5 M.
The PowerMax system with SCM drives and other performance features can provide unparalleled levels of IOPS at very low latencies for mission-critical applications.