Home > Workload Solutions > SQL Server > White Papers > Dell EMC PowerMax Storage for Mission-Critical SQL Server Databases > Test case 2: Scale test
Test case 2 demonstrates the ability of PowerMax to scale for SQL Server databases supporting two different applications that are running OLTP workloads.
We ran two OLTP workloads on SQL Server databases at Diamond service levels running on two identical servers. While the test ran, we monitored host IOPS, SQL Server TPM, and read and write response times.
As the test results in the following figure show, PowerMax supported both highly demanding workloads very effectively. Both databases performed in a balanced fashion with overall cache read hits of 47%.
Figure 8. Scale test for two independent SQL Server databases
Test case 2 demonstrated read and write response times of around 0.4 ms for both databases. Even with such low response times, SQL Server databases on PowerMax allowed for host IOPS of 430,000 for both SQL server databases and OLTP TPM of over 2 M each. The total TPM for both databases was close to 4.3 M.
The PowerMax system can support multiple highly demanding workloads simultaneously while providing consistent performance. Comparing the results with Test Case 1, we can see that the PowerMax system scales well. Even with a limited number of SCM drives (8 in our test case), multiple competing workloads can still achieve high performance at low latencies.