Microsoft and HP have set two world records for data warehousing in performance and price/performance categories.
Each of the world records showed Microsoft’s SQL Server data platform breaking the previously held record by Oracle/SPARC on both categories by significant margins.
In the TPC Benchmark-H (TPC-H) ten terabyte benchmark, the HP ProLiant DL580 Gen8 Server with SQL Server 2014 Enterprise Edition and Windows Server 2012 R2 Standard Edition achieved a world record non-clustered performance of 404,005 query-per-hour (QphH).
This compares to topping the held record from Oracle/SPARC of 377,594 QphH.
The results for the price/performance metric was US$2.34 Dollar/Query-per-Hour ($/QphH) compared to Oracle’s $4.65 $/QphH1
In the TPC-H three terabyte benchmark, the same HP server with SQL Server 2014 Enterprise Edition and Windows Server 2012 R2 Standard Edition achieved a world record non-clustered performance of 461,837 QphH
The previous world record was held by Oracle/SPARC at 409,721 QphH.
The SQL Server configuration again beat Oracle’s world record of $3.94 $/QphH with a price/performance result of US$2.04 $/QphH.
The TPC-H is an industry standard decision support benchmark that consists of a suite of business oriented ad-hoc queries and concurrent data modifications.
The queries and the data populating the database have been chosen to have broad industry-wide relevance.
This benchmark illustrates decision support systems that examine large volumes of data, execute queries with a high degree of complexity, and give answers to critical business questions.
Share this story