. Faster, more powerful handling of database workloads
ABBE Technology Solutions, Inc.
 
 
Our

Blogs

Faster, more powerful handling of database workloads

  • Date Published: August 05, 2020
Faster, more powerful handling of database workloads

Faster, more powerful handling of database workloads


The new Intel processor-based Dell EMC PowerEdge R740xd offers better virtualized database performance compared to the legacy PowerEdge R720


The pace of business is lightning fast. Technology runs faster—and customers want service even faster still. To keep up with the demands of a company in this age, you need hardware infrastructure capable of supporting large amounts of work with a more responsive customer experience. Our work in the Principled Technologies datacenter showed that the 14th generation Dell EMCTM PowerEdgeTM R740xd, with Intel processors and VMware products, could deliver just that.

We ran an online transaction processing (OLTP) workload on a cluster of PowerEdge R740xd servers with VMware® vSphere® 6.5, VMware vSANTM storage, and the Intel® Xeon® Scalable processor. We then compared its performance to that of a 12th generation PowerEdge R720 server cluster using traditional HDD storage. We measured three key metrics: database orders processed per minute (OPM), input/output operations per second (IOPS), and storage latency.

In all our database performance testing, the Dell EMC PowerEdge R740xd far surpassed the PowerEdge R720, showing results that could help your business serve users better.




How we tested

We compared the new 14th generation Dell EMC PowerEdge R740xd to the 12th generation PowerEdge R720 in a series of tests designed to assess how much data each system is able to process, and how an end-user’s experience is affected while the system is under stress.

We tested two separate ESXi® server clusters, each comprised of two hosts. The PowerEdge R740xd cluster used VMware vSAN for storage, with PCIe SSDs as the caching tier and read-intensive SAS SSDs as the capacity tier. The legacy PowerEdge R720 server cluster used a HDD-based SAN storage array, which is a configuration typical for its time. We used DVD Store 2, a database-intensive ecommerce test application, to assess each server cluster’s performance while processing a simulated online transaction processing (OLTP) workload. See Appendix B for detailed testbed information.




Expand your work with the PowerEdge R740xd

Serving customers is key for any business. With the speed of its NVMe SSD-driven VMware vSAN storage, and using the latest-generation Intel Xeon Scalable processor, the PowerEdge R740xd cluster running VMware vSphere 6.5 processed 78,787 database operations per minute (OPM). The PowerEdge R720 server cluster, also running VMware vSphere 6.5, only managed 9,625 OPM. With servers capable of fulfilling eight times the customer operations, you’ll be able to increase the performance of your hypervisors while keeping up with the speed of business, leading to a better experience for your users. Your organization could also cut down on its datacenter footprint by purchasing fewer servers to support your current workload. But you also have the opportunity to invest in more hardware and plan for inevitable future work. Furthermore, the 14th generation servers running VMware vSphere 6.5 with vSAN processed 12 times the IOPS of the older PowerEdge server. Having better raw IOPS could mean being able to support even tougher workloads when your company needs them.




Serve customers better with fast response times

Many business operations need to happen quickly. Failing to meet these expectations can lead to customer dissatisfaction or even loss. That’s why it’s critical to ensure your servers can communicate and process information as fast as possible, without lag or delay. The Dell EMC PowerEdge R740xd solution had 98.46 percent lower storage latency than the PowerEdge R720, making for a smoother, more responsive user experience.




Conclusion: Refresh to drive your business further

Your datacenter may be working fine to support your business operations—but after several years, a refresh could help you propel your company’s level of work forward. In our hands-on tests, the Dell EMC PowerEdge R740xd combined with the latest generation of Intel Xeon Scalable processors proved to be a workhorse. In a VMware vSAN cluster, the PowerEdge R740xd processed eight times the OPM and 12 times the IOPS with 98.46% lower latency than the 12th generation PowerEdge R720. Our results show that purchasing newer, more powerful servers can enable you to better serve your current users and make room for more in the future.








A Principled Technologies report: Hands-on testing. commissioned by Dell Technologies.