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.
Related Blog Posts
The Dell PowerEdge R7525: a Leader in Price and performance for SQL Server 2019
Mon, 07 Feb 2022 21:44:20 -0000
|Read Time: 0 minutes
The Microsoft Server team at Dell Technologies is excited to announce the recently published decision support workload benchmark (TPC-H) that has the Dell PowerEdge R7525 as the price performance leader according to the 10,000 GB results published on December 15th, 2021. The Transaction Processing Council (TPC) provides the most trusted sources of independently audited database performance benchmarks. These TPC benchmarks provide a way for customers to compare the performance of servers using different sized workloads.
The Dell PowerEdge R7525 is a two-socket server that uses AMD EPYC processors and supports up to 4TB of memory, making it a strong choice for database workloads. The AMD EPYC 73F3 processor has 16 CPU cores and a base clock speed of 3.5 GHz that can boost up to 4.0 GHz. The base clock speed of 3.5 GHz for the CPU cores enables quick data processes, which enhances database value for customers.
We configured the Dell PowerEdge R7525 with two AMD EPYC 73F3 processors for a total of 32 physical cores and with hyperthreading 64 threads. The server was configured with the maximum amount of memory (4 TB) with DDR4-3200 DRAM in a 32 by 128 GiB memory configuration. The server storage configuration included ten 1.92 TB SSD drives and eight 6.4 enterprise NVMe drives. For the complete PowerEdge R7525 configuration, see the TPC Benchmark H Full Disclosure Report.
We used Microsoft SQL Server 2019 Enterprise Edition and Red Hat Enterprise Linux 8.3 for the TPC-H workload. The decision support workload (TPC-H) is designed to examine volumes of data, execute queries with a high degree of complexity, and provide answers to critical business questions. The key performance metric is the Composite Query-per-Hour (QphH@Size) for decision support benchmarks. The PowerEdge R7525 achieved a 960,382 QphH@Size rating with a 10,000 GB database size. To determine the price performance metric the total system cost of $379,133 USD was divided by the queries per hour. The price performance metric of $394.78 $/kQphH@10000GB placed the PowerEdge R7525 a leader in this category.*
The Microsoft team at Dell Technologies has recently published best practices for SQL Server, many of which were used in this independently audited TPC-H benchmark. To review these best practices that provide insights into how organizations can optimize their SQL Server environments, see this link: AMD-based SQL Server Best Practices.
The SQL Server Best Practices program includes the following:
- VMware ESXi: Round Robin Path Policy
- PowerMax: Adding Storage Groups
- PowerMax: Storage Directors Ports and Interface Emulations
- SQL Server 2019: CPU Affinity
The solutions page for Microsoft SQL Server provides an overview of how Dell Technologies and Microsoft SQL Server can enable your company with modern infrastructure and agile operations. To learn more, see Dell Technologies Solutions for Microsoft Data Platform.
For those interested in harnessing the performance of the AMD-based PowerEdge R7525 server see, PowerEdge R7525 rack server web page. This provides an overview and technical specifications of the PowerEdge R7525 server.
Dell Technologies offers a portfolio of other rack servers, tower and modular servers that can be configured to accelerate most any business workload. To learn more about these options, see Dell Technologies PowerEdge Server Solutions.
* Based on TPC Benchmark H (TPC-H), December 15th, 2021, the Dell EMC PowerEdge R7525 rack server has a TPC-H Composite Query-per-Hour Performance Metric of 960,382 and a price/kQphH metrick of 394.79 USD when run against a 10,000 GB Microsoft SQL Server 2019 database and Red Hat Enterprise Linux 8.3 in a non-clustered environment. Actual results may vary based on operating environment. Full results are available at tpc.org.
SQL Server Modernization: 7X Performance Gains, 5.25X Faster Rebuilds
Tue, 26 Oct 2021 09:51:41 -0000
|Read Time: 0 minutes
Upgrading to the latest server generation significantly improves performance and data protection
When it comes time to modernize with Microsoft® SQL Server 2019® to take advantage of its significant advancements for extracting real-time insights from data-intensive workloads, it makes sense to consider an upgrade to the underlying hardware as well.
The latest generation of Dell EMC PowerEdge servers can help SQL Server transform raw data into actionable insights with better performance and data protection. These servers are highly adaptable for seamless scaling and equipped to meet the demands of real-time analytics, artificial intelligence (AI) and machine learning (ML).
To help you put some numbers around your infrastructure decision, Dell Technologies recently asked a third-party consulting firm, Prowess Consulting, to test SQL Server performance on the latest generation of Dell EMC PowerEdge servers, compared to the previous generation.
The testing demonstrates that the latest server generation with RAID storage based on the latest NVMe™ drives can significantly improve SQL Server 2019 performance, capable of processing more than 7X more new orders per minute (NOPM).[1] In addition, RAID array rebuild times were up to 5.25X faster on the newer platform, enabling significantly faster recovery and less downtime.1
These remarkable improvements in performance and data protection are driven by a variety of new technologies incorporated in PowerEdge servers:
- Latest processors with higher core counts: Compared to the previous generation, 3rd Generation Intel® Xeon® Scalable processors are built on a more efficient architecture that increases core performance, memory, and I/O bandwidth and provides additional memory channels to accelerate workloads. In addition, it supports more cores and sockets to further enhance performance and throughput.
- More and faster memory: The 3rd Generation Intel Xeon Scalable processors offer more cores and supports more memory modules (DIMMs) at the same price, for up to 1.60X higher memory bandwidth1 and up to 2.66X higher memory capacity.1
- NVMe™ drives with PCIe® Gen4: Compared to the SATA RAID drives with PCIe Gen3 used previously, the latest generation of NVMe solid-state drives paired with PCIe Gen4 interfaces doubles server throughput.1
- Revolutionary RAID controller technology: The new Dell PERC H755N front NVMe adapter is based on the Broadcom® SAS3916 PCIe to SAS/SATA/PCIe RAID on Chip (RoC) controller. These are the first RAID controllers from Dell Technologies to offer both PCIe Gen4 host and PCIe Gen4 storage interfaces, which deliver double the bandwidth and 75% more IOPS compared to previous generations.1
- Ethernet controllers: The Broadcom NetXtreme® E-Series P425G 4x 25G PCIe NIC combines a high-bandwidth Ethernet controller with a unique set of highly optimized hardware-acceleration engines to enhance network performance and improve server efficiency for enterprise and cloud-scale networking and storage applications, including AI, ML, and data analytics.
Taken together, these modern features deliver a significant SQL Server performance boost with higher-capacity storage and faster database rebuild times. They also greatly increase IT efficiency, a topic we’ll look at in more detail in the next blog.
Learn more
Read the report: Can Newer Dell EMC Servers Offer Significantly Better Performance for Microsoft SQL Server?
Visit: DellTechnologies.com/Microsoft-Data-Platform
Visit: DellTechnologies.com/PowerEdge
[1] Dell EMC R750 server compared with similarly-configured Dell EMC PowerEdge R740xd server. Source: Prowess white paper, sponsored by Dell Technologies, “Can Newer Dell EMC Servers Offer Significantly Better Performance for Microsoft SQL Server?” August 2021. Actual results may vary.