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
The performance metric reported for TPC-H is the Composite Query-per-Hour Performance Metric ([email protected]). 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
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.1
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.
More information about this testing is available on the PowerEdge R940xa TPC-H Benchmark Data Sheet. For technical information, see the PowerEdge R940xa rack server page for specifications, customizations, and details. In addition,
Learn more about Microsoft SQL Server Solutions:
We welcome you to join us at Microsoft Ignite this week. Registration for this virtual event is open to all and will be an excellent opportunity to learn how Microsoft and
Are you more interested in an overview of the many solutions for SQL Server? For a business overview of how
¹ Based on TPC Benchmark H (TPC-H),
.
(C) 2020 M2 COMMUNICATIONS, source