Dell PowerEdge R7525 Server – AMD Performance for Microsoft SQL Server workloads running on RHEL 8.3
Wed, 19 Jan 2022 21:30:10 -0000
|Read Time: 0 minutes
The Dell EMC PowerEdge R7525 is a highly scalable two-socket 2U rack server that delivers powerful performance and flexible configuration, ideal for data analytics workloads. It features a 2nd Gen AMD EPYC 7002 series processors with up to 24 NVMe drives that provide a unique combination non-oversubscribed NVMe storage and plenty of peripheral options to support applications that require maximum performance.
For this benchmark, the PowerEdge R7525 was subjected to an intense workload over 8 contiguous hours which included necessary operations such as backups. The R7525 emerged with an impressive 1,542,560 QphH@3,000GB TPC Benchmark H (TPC-H) performance rating.
Based upon the results on July 03, 2021, tcp.org, a Decision Support Benchmark organization, the Dell PowerEdge R7525 Server demonstrated a TPC-H Composite Query-per-Hour metric of 1,542,560 when run against a 3,000GB database yielding a TPC-H Price/Performance of rating of $327.38 per query-per-hour.
This performance was realized based on the installation of Microsoft SQL Server 2019 Enterprise Edition 64 bit on a Red Hat Enterprise Linux Server Release 8.3
Based on TCP-H V3 benchmarks in the 3,000 Scale Factor Range, this system has demonstrated an outstanding price to performance ratio. You can view the tcp.org results here.
Performance Measurement |
|
Performance | 1,542,560 QphH@3,000GB |
Price Performance | $327.38 per 1,542,560 QphH@3,000GB |
System Information |
|
Processors | 2x AMD EPYC MILAN 75F3, 2.95GHz (2 Proc / 64 Cores / 128 Threads) |
Memory (6TB) | 2048 GB (16x 128GB LRDIMM,3200MT/s, Quad Rank) |
Storage | BOSS controller card + with 2 M.2 Sticks 480GB (RAID 1), LP |
| 4 * 800GB SSD SAS Mix Use 12Gbps512e 2.5in AG Drive,3 DWPD |
| 3 *960GB SSD SAS Read Intensive12Gbps 512 2.5in AG Drive, 1 DWPD |
| 8 * Dell 1.6TB, NVMe, Mixed Use Express Flash, 2.5 SFF Drive, U.2, P4610 |
Why TPC Benchmarks matter
TPC-H is a decision support benchmark recorded at tpc.org. This benchmark consists of a suite of business-oriented ad-hoc queries and concurrent data modifications. The queries and data populating the database simulate a broad industry-wide relevance while maintaining easy implementation. This benchmark illustrates decision support systems that:
- Examine large volumes of data
- Execute queries with a high degree of complexity
- Give answers to critical business questions
Microsoft’s SQL Server is an enterprise-class database platform that more and more companies are using to store critical and sensitive data. SQL Server is an important cog in Microsoft’s.NET enterprise server architecture. It’s easy to use and takes fewer resources to maintain and performance tune.
The PowerEdge R7525 features 3rd Gen AMD EPYC series processors with Dell NVMe drives that provide a unique combination non-oversubscribed NVMe storage along with plenty of peripheral options to support applications that require maximum performance
This measurement is beneficial to a wide range of businesses that use Microsoft’s SQL Server as their enterprise-class database platform. More and more companies are using Microsoft’s SQL Server to store critical and sensitive data. SQL Server remains an important cog in Microsoft .NET enterprise server architecture. It’s easy to use and requires fewer resources to maintain and performance tune.
To find resources for system that is the right fit for your SQL Server see the Dell Technologies SQL Server support page.
Additional Dell Technologies Validated Designs to fit your current and future SQL requirements:
- Consolidated Mixed Workloads
- Re-platform Microsoft SQL to Linux
- Run Microsoft SQL on Containers
- Deploy Microsoft SQL 2019 Big Data Clusters
To explore these options, visit the Dell Technologies Solutions for Microsoft Data Platform.