After our first look at EMC's VxRack Node running in HCI mode measuring synthetic workload performance, we turn our attention to SQL Server OLTP performance. In this particular test our focus is on application-level latency, instead of completely stressing the system in terms of both CPU and storage I/O. To find out just how well ScaleIO holds up under pressure, we put its HCI configuration head to head against its phenominal two-layer results to see if EMC has a few tricks up its sleeve.
VxRack Node (Performance Compute All Flash PF100) Specifications
SQL Server Performance
Each SQL Server VM is configured with two vDisks; 100GB volume for boot and a 500GB volume for the database and log files. From a system resource perspective, we configured each VM with 16 vCPUs, 64GB of DRAM and leveraged the LSI Logic SAS SCSI controller. While our Sysbench workloads tested previously saturated the platform in both storage I/O and capacity, the SQL test is looking for latency performance. Being an HCI configuration, we have one SQL Server VM running on each of the four PF100 VxRack Nodes. At the time this data was collected, we were running ESXi 5.5 on the cluster, whereas our two-layer results were measured inside an ESXi 6.0 environment.
This test uses SQL Server 2014 running on Windows Server 2012 R2 guest VMs, being stressed by Dell's Benchmark Factory for Databases. In this test we spread out four 1,500-scale databases evenly across the EMC VxRack Node to illustrate the aggregate performance inside a 4-node VMware cluster.
SQL Server Testing Configuration (per VM)
SQL Server OLTP Benchmark Factory LoadGen Equipment
In the SQL Server TPC-C test, we look for workload balance across the cluster. With four VMs running in steady-state on four VxRack PF100 Nodes in an HCI configuration, we measured performance ranging from 3154.7 TPS to 3155.8 TPS on the low sidel. In aggregate we saw cluster-wide performance measure 12,621.7 TPS on the ScaleIO HCI cluster. Across the board ScaleIO in HCI outpaced the same storage presented to an outside compute cluster in two-layer mode.
Looking at average latency across our 4 SQL VMs, we were surprised to see how well ScaleIO in an HCI configuration compared to two-layer. We've never seen HCI platforms surpass traditional storage with outside compute resources. Most of the time this is caused by compute overhead from the storage components sharing the same compute resources as the workloads. In the case of ScaleIO though, it obviously had no impact, even though we had lower-end CPUs (2.5GHz vs 2.6GHz) in these nodes compared to the servers we used in two-layer testing. Application latency across four VMs ranged from 10ms to 11ms, with an aggregate average of 10.3ms.
Conclusion
In our first look at application performance with EMC's ScaleIO VxRack Node in HCI, we are still surprised by just how well it performs. When running the application on the same hardware as the storage resources, ScaleIO software has no negative hit to the workload itself. This is an impressive feat in and of itself, considering other HCI platforms almost always sap a large percentage of CPU resources to manage background processes (some as high as 30%). To that end, our HCI results surpassed those that we measured with ScaleIO in two-layer mode, dropping average latency from 12.5ms average down to 10.3ms. For customers demanding the highest performing hyper-convereged storage solution for SQL Server, ScaleIO just upped the bar again by being the most efficient HCI solution we've ever tested.
EMC VxRack Node Review: Overview
EMC VxRack Node Powered By ScaleIO: Scaled Sysbench OLTP Performance Review (2-layer)
EMC VxRack Node Powered By ScaleIO: SQL Server Performance Review (2-layer)
EMC VxRack Node Powered By ScaleIO: Synthetic Performance Review (2-layer)
EMC VxRack Node Powered By ScaleIO Review: Synthetic Performance Review (HCI)
EMC VxRack Node Powered By ScaleIO: VMmark Performance Review (HCI)
The Supermicro AS-1115SV-WTNRT features AMD EPYC 8804 CPUs that offer up to 64 cores with an efficient 200W TDP. (more…)
The Graid SupremeRAID SR-1001 is an excellent choice for those seeking to balance cost with performance in small NVMe RAID…
With ransomware attacks on the rise, there's no easier-to-use solution for Veeam to protect your data than Ootbi by Object…
The Dell Precision 5690 laptop is surprisingly lightweight but packs a powerful punch, our review unit includes a NVIDIA RTX…
The UGREEN DXP480T Plus offers an alluring blend of portability and performance in a tiny body with 4 M.2 NVMe…
TrueNAS has gained traction in the self-host and homelab communities for several reasons. One primary reason is that it's free…