Microsoft SQL Server 2019 TPC-H Performance on Dell EMC PowerEdge R7515
Mon, 14 Jun 2021 14:44:40 -0000
|Read Time: 0 minutes
Dell EMC PowerEdge R7515 servers with AMD 75F3 processors deliver impressive performance and price/performance for SQL Server 2019.
While modernizing your data center there are two very important considerations every organization must make. The first is the price of new hardware and the other is how will it perform.
The latest powerful AMD 75F3 processors change the economics of the datacenter for the better. The Dell EMC PowerEdge R7515(2U) server, with the AMD processors, delivers the balanced I/O, memory, and computing capacity needed for large-scale analytical and business intelligence applications.
The latest generation PowerEdge R7515 servers mean organizations will not have to compromise neither on performance nor cost and instead focus on realizing their IT and digital business potentials. Independent tpc.org auditing has demonstrated that these servers are top rated in performance and price/performance for @ 1,000GB scale factor Microsoft SQL Server 2019 Enterprise database with Red Hat Enterprise Linux 8 operating system in a non-clustered environment.[1] Powered by 3rd generation AMD® EPYC™ processors, these servers are capable of handling demanding workloads and applications, such as data warehouses, ecommerce, databases. For more details about Dell servers please visit the Dell website.
Results (Source: Tpc.org as of May 03,2021)
The Dell PowerEdge R7515 server achieved a result of 9,79,335.3 QphH@1000GB and $269.23 $/kQphH@1000GB and with system availability as of Apr 29, 2021. Results were officially published on the TPC org website on May 3,2021. *[2]
Check out the TPC-H V3 Result Highlights for additional information on the benchmark configuration. The detailed official benchmark disclosure report at TPC Results Page.
AMD EPYC 75F3 Processor:
The AMD EPYC™ 7003 Series Processors are built with leading-edge Zen 3 core, and AMD Infinity Architecture. The AMD EPYC™ SoC offers a consistent set of features across 8 to 64 cores. Each 3rd Gen AMD EPYC processor consists of up to eight Core Complex Die CCD) and an I/O Die (IOD).
Benchmarking SQL Server 2019 with Dell EMC PowerEdge R7515 Server:
Microsoft SQL Server was configured on PowerEdge R7515 server with the following configuration. The PowerEdge R7515 server was equipped with single EPYC 75F3 3.3GHz, 32C/64T, 256M Cache (280W) DDR4-3200 and 1 TB of memory (up to 2 TB supported). Storage for this system was eight 1.6TB NVME Gen3 Mixed use Express Flash Drives plus four 480GB SSD SAS mixed use drives and three 480GB SATA read intensive SSD drives. The system ran Microsoft SQL Server 2019 Enterprise Edition and Red Hat Enterprise Linux 8. For technical information, see the R7515 rack server page for specifications, customizations, and details.
You can visit the FDR report for additional information on the benchmark configuration.
Performance:
The performance test consists of two runs:
A run consists of one execution of the Power test followed by one execution of the Throughput test.
RUN 1 is the first run following the load test. Run 2 is the run following Run 1. Below are the RUN1 and RUN2 results. For more detailed information please go through the FDR report.
Dell Technologies solutions for Microsoft SQL Server:
Dell Technologies solutions simplify the deployment, integration and management of Microsoft data platform environments and accelerate time-to-value for better service delivery and business innovation. With a broad infrastructure portfolio and a long-standing partnership with Microsoft, we provide the innovative solutions that reduce complexity and enable you to solve today’s challenges, no matter where you are in your transformation journey.
We have already released 10 TB TPC-H benchmarks on 4-S R940xa server. For More information about this the testing config and results please visit Dell EMC PowerEdge R940xa Full Disclosure Report.
In addition, Dell Technologies offers a portfolio of other rack servers, tower servers, and modular infrastructure that can be configured to accelerate most any business workload. For more details about Dell Technologies Solutions for Microsoft SQL please visit https://www.delltechnologies.com/sql
[1] *Based on TPC Benchmark H (TPC-H), May 2021, at 1,000 GB the Dell EMC PowerEdge R7515 server, priced at $263,658.00 USD, has a TPC-H (V3) Composite Query-per-Hour metric of 979,335.3 yielding a TPC-H Price/Performance of $269.23 USD / kQphH@1,000 GB with Microsoft SQL Server 2019 Enterprise Edition database and Red Hat Enterprise Linux 8 operating system, in a non-clustered environment. Actual results may vary. Full results on tpc.org.
[2] Based on TPC Benchmark H (TPC-H), May 2021, at 1,000 GB the Dell EMC PowerEdge R7515 server, priced at $263,658.00 USD, has a TPC-H (V3) Composite Query-per-Hour metric of 979,335.3 yielding a TPC-H Price/Performance of $269.23 USD / kQphH@1,000 GB with Microsoft SQL Server 2019 Enterprise Edition database and Red Hat Enterprise Linux 8 operating system, in a non-clustered environment. Actual results may vary. Full results on tpc.org.