We performed testing in the Dell EMC Ready Solution engineering lab on a Dell EMC S2D all-flash Ready Node using the PowerEdge R640 server. We used the industry-standard TPC-E-like benchmark.
We deployed eight OLTP databases of 500 GB each on a SQL Server 2017 instance on the S2D cluster. SQL Server binaries and VM files were kept on parity volumes (two-way mirroring). Other database files (DB, log, and tempdb files) were kept on three-way mirrored volumes. We performed a step-stress test using the Benchmark Factory tool to understand the scalability of the OLTP workload. We simulated the TPC-E workload with 100 concurrent virtual users for each VM to stress the SQL VMs while maintaining the 1 millisecond (ms) storage latency.
The following figure shows the test methodology for implementing one VM workload at a time and linearly increasing the workload.
Figure 6. Test methodology for VM workload implementation
The following figure shows the average TPS and average query response time (AQRT) with an increasing number of VMs on a four-node S2D all-flash Ready Node cluster.
Figure 7. OLTP performance: Average TPS and AQRT with increasing number of VMs