Dell EMC PowerEdge R940xa Server is the Leader in Price/Performance for SQL Server 2019
Download PDFMon, 16 Jan 2023 13:44:24 -0000
|Read Time: 0 minutes
Summary
The Transaction Processing Performance Council (TPC) published that the Dell EMC PE R940xa is the leader in Price per Performance for SQL Server 2019 in the 4S and 10TB category.1 This DfD will educate readers of what this means, and why this is so important for today’s compute intensive workloads.
Leader in Price/Performance
The Dell EMC PowerEdge R940xa 4 socket (4S) server ranked #1 in price/performance in the 10TB SQL Server category, as published by the Transaction Processing Performance Council (TPC). The analysis showed that the PowerEdge R940xa delivered $0.67 USD per query-per-hour for a 10TB SQL Server 2019 database in a non-clustered environment. This metric was computed by dividing the R940xa server price by the TPC-H Composite Query-per-Hour (QphH) performance. 1
The PowerEdge R940xa delivers these results with powerful performance from the combination of four CPUs and four GPUs to drive database acceleration at a competitive price point. This performance is ideal for compute-intensive workloads like SQL Server and allows users to scale business-critical workloads with:
• Up to four 2nd Generation Intel Xeon Scalable processors and up to 112 processing cores
• Up to four double-width GPUs or up to four double-width or eight single-width FPGAs to accelerate workloads
• Up to 48 DIMMs (24 of which can be DCPMMs) and up to 15.36TB of memory for large data sets
• 32 2.5” HDDs/SSDs, including four NVME drives
• Up to 12 PCIe slots for external connections
Impact to Server Users
This superior price per performance means that PowerEdge R940xa server users have optimized returns per dollar for compute-intensive workloads. Datacenter owners can also reinvest their financial savings into alternative segments to achieve their desired goals.
*To see the official TPC website results please click here.
Related Documents
Dell PowerEdge R940xa Server is the Leader in Price/Performance for SQL Server 2019
Tue, 17 Jan 2023 07:20:42 -0000
|Read Time: 0 minutes
Summary
The Transaction Processing Performance Council (TPC) published that the Dell EMC PE R940xa is the leader in Price per Performance for SQL Server 2019 in the 4S and 10TB category.1 This DfD will educate readers of what this means, and why this is so important for today’s compute intensive workloads.
Leader in Price/Performance
The Dell EMC PowerEdge R940xa 4 socket (4S) server ranked #1 in price/performance in the 10TB SQL Server category, as published by the Transaction Processing Performance Council (TPC). The analysis showed that the PowerEdge R940xa delivered $0.67 USD per query- per-hour for a 10TB SQL Server 2019 database in a non-clustered environment. This metric was computed by dividing the R940xa server price by the TPC-H Composite Query-per-Hour (QphH) performance. 1
The PowerEdge R940xa delivers these results with powerful performance from the combination of four CPUs and four GPUs to drive database acceleration at a competitive price point. This performance is ideal for compute-intensive workloads like SQL Server and allows users to scale business-critical workloads with:
- Up to four 2nd Generation Intel Xeon Scalable processors and up to 112 processing cores
- Up to four double-width GPUs or up to four double-width or eight single-width FPGAs to accelerate workloads
- Up to 48 DIMMs (24 of which can be DCPMMs) and up to 15.36TB of memory for large data sets
- 32 2.5” HDDs/SSDs, including four NVME drives
- Up to 12 PCIe slots for external connections
Impact to Server Users
This superior price per performance means that PowerEdge R940xa server users have optimized returns per dollar for compute-intensive workloads. Datacenter owners can also reinvest their financial savings into alternative segments to achieve their desired goals.
*To see the official TPC website results please click here.
Dell PowerEdge MX760c servers handle 19.7% more SQL Server work and support 25% more VMs
Thu, 16 Mar 2023 17:12:23 -0000
|Read Time: 0 minutes
Principled Technologies tested a VMware cluster of new 16th generation Dell PowerEdge MX servers. This accomplished more OLTP orders per minute and increased VM density compared to a similarly configured 15th generation MX750c.
Figure 1: Performance of the previous-generation cluster with 24 VMs and the new-generation cluster with 30 VMs. Higher OPM and lower latency are better.
A sample OLTP database workload was used in the test as OLTP plays a crucial role in many digital business processes, such as retail transactions, inventory tracking, customer relationship management, and other business operations. Based on Microsoft SQL Server 2019 DVD using Store 3 hosted in multiple virtual machines, the workload testing targeted the maximum orders per minute (OPM) each cluster could achieve. This was done by increasing the thread count and decreasing the think time until performance degraded. The testing found customers can accelerate existing virtual machines by a simple lift and shift vMotion-type migration to the newer compute sled. However, due to the extra performance available from the new MX760c platform, thanks in part to its 4th Generation Intel Xeon Scalable processors, it was also found additional workloads could be added while still maintaining the required performance.
Figure 2: Total orders per minute the two clusters achieved with 24VMs.
Figure 3: Total orders per minute the two clusters achieved with 30 VMs.
Regarding workloads, new-generation Dell PowerEdge MX760c servers can offer compelling performance gains. 16th Generation Dell PowerEdge MX760c servers can simultaneously provide increased workload performance and VM density.