Saturday 26 September 2020

Dell Technologies Achieves Top Ranking in SQL Server TPC-H Benchmark

Dell EMC Study Materials, Dell EMC Exam Prep, Dell EMC Learning, Dell EMC Guides

If you want to find a list of the 20 best electric toothbrushes for 2020, you have plenty of options. But where do you go when you want to see a list of the top 10 data warehouse technologies?—probably not your regular social media channels. For those of you who don’t follow database benchmarking news, it’s the Transaction Processing Performance Council (TPC) that provides the most trusted source of independently audited database performance benchmarks. Two of TPC’s primary activities are creating good benchmarks and creating a process for auditing those benchmarks.

Dell Technologies recently achieved the top position on the TPC (tpc.org) leaderboard for the decision support workload benchmark (TPC-H) price/performance results for a 10,000 GB database. This benchmark tests decision support systems that are designed to examine large volumes of data, run highly complex queries, and provide answers to critical business questions. The TPC-H top-ranked system for price/performance was the Dell EMC PowerEdge R940xa server running Microsoft SQL Server 2019 Enterprise Edition with the Windows Server 2019 operating system.

Dell EMC Study Materials, Dell EMC Exam Prep, Dell EMC Learning, Dell EMC Guides

The performance metric reported for TPC-H is the Composite Query-per-Hour Performance Metric (QphH@Size). Most database benchmarks for high-transaction workloads are stated in transactions per second (TPS). The queries-per-hour calculation for the decision support benchmark is the result of the queries being far more complex than most OLTP transactions. The decision support queries include a rich combination of transformation operators and selectivity constraints that generates intense activity on the database server being tested.

When it comes to choosing servers that will perform well with many concurrent decision support requests, the configuration is critically important. In our Dell labs, we worked on a configuration that provided a balance between price and performance. The PowerEdge R940xa server used for this benchmark was configured with four Intel Xeon Platinum 8280L processors supplying 112 cores (224 logical cores with Intel Hyper-Threading) plus 6 TB of memory. Storage for the benchmark system was supplied by ten 1.6 TB Mix Use SAS SSDs capable of 12 Gbps plus four 6.4 TB Mixed Use Express Flash NVMe small form factor 2.5-inch drives. The Dell engineers achieved 1,420,550.7 TPC-H Composite Query-per-Hour (QphH@10,000 GB) with price/performance of $0.67 USD/QphH@10,000 GB. The TPC Benchmark H Full Disclosure Report is available on the TPC website.    

Benchmarks that rank database systems using real-world workloads typical of decision support environments provide insights to IT professionals by providing a comparison of both price and performance. Perhaps the most important advantage of considering benchmarks when evaluating technology options is the value added by having an independent analysis of test results. The independent analysis means the benchmark results have integrity and show where a system stands compared with other systems. Anyone can then look at the system configuration in the TPC Full Disclosure Report to understand how the system was configured to achieve a top price/performance result. For IT professionals, the report results mean that PowerEdge R940ax servers are among the top price/performance systems for accelerating decision support and similar systems for a 10 TB SQL Server 2019 database.

SQL Server, along with other RDBMS products from leading vendors, is quite efficient at using memory and solid-state-drive technology. More memory and faster disk drives can usually improve database performance for many types of workloads. With its multiple configuration options, the PowerEdge R940xa can accelerate many databases workloads, such as decision support, online transaction processing, data warehouses, and more.

Source: dellemc.com

Related Posts

0 comments:

Post a Comment