HP sets world data warehousing records on SQL Server 2014

By Karen McCandless on 22 April 2014

HP sets world data warehousing records on SQL Server 2014

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.