{"id":1213,"date":"2014-04-16T07:30:00","date_gmt":"2014-04-16T14:30:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2014\/04\/16\/sql-server-2014-and-hp-sets-two-world-records-for-data-warehousing-leading-in-both-performance-and-priceperformance\/"},"modified":"2024-01-22T22:52:12","modified_gmt":"2024-01-23T06:52:12","slug":"sql-server-2014-and-hp-sets-two-world-records-for-data-warehousing-leading-in-both-performance-and-priceperformance","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2014\/04\/16\/sql-server-2014-and-hp-sets-two-world-records-for-data-warehousing-leading-in-both-performance-and-priceperformance\/","title":{"rendered":"SQL Server 2014 and HP Sets Two World Records for Data Warehousing Leading In Both Performance and Price\/Performance"},"content":{"rendered":"

Yesterday we talked about how we are delivering real-time performance to customers in every part of the platform.\u00a0 I\u2019m excited to announce another example of where we are delivering this to customers in conjunction with one of our partners.\u00a0Microsoft and Hewlett Packard broke two world records in TPC-H 10 Terabyte and 3 Terabyte benchmarks for non-clustered configuration for superior data warehousing performance and price-performance. Each of the world records showed SQL Server breaking the previously held record by Oracle\/SPARC on both performance and price\/performance\u00a0<\/sup>by significant\u00a0<\/sup>margins.<\/p>\n

10TB<\/b>: Running on a HP ProLiant\u00a0DL580 Gen8\u00a0Server with SQL Server 2014 Enterprise Edition and\u00a0Windows\u00a0Server 2012 R2 Standard Edition, the configuration achieved a world record non-clustered performance of 404,005 query-per-hour (QphH) topping the previously held record from Oracle\/SPARC of 377,594 query-per-hour (QphH).\u00a0 The SQL Server configuration also shattered the Price\/performance metric with a $2.34 USD Dollar\/Query-per-Hour ($\/QphH) topping Oracle\u2019s $4.65 $\/QphH<\/p>\n

3TB:<\/b>\u00a0Running on a HP ProLiant\u00a0DL580 Gen8\u00a0Server with SQL Server 2014 Enterprise Edition and Windows Server 2012 R2 Standard Edition, the configuration achieved a world record non-clustered performance of 461,837 query-per-hour (QphH) topping the previously held record from Oracle\/SPARC of 409,721 query-per-hour (QphH).\u00a0 The SQL Server configuration also shattered the Price\/performance metric with a $2.04 USD Dollar\/Query-per-Hour ($\/QphH) topping Oracle\u2019s $3.94 $\/QphH<\/p>\n

By breaking the world records for both performance and price\/performance validates how SQL Server 2014 is delivering on leading in-memory performance at exceptional value. It also validates SQL Server\u2019s leadership in data warehousing.<\/p>\n

\"<\/a><\/p>\n

The TPC Benchmark\u2122H (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.\u00a0 The performance metric is called the TPC-H Composite Query-per-Hour Rating and the price\/performance metric is the cost \/ performance metric.<\/p>\n

Eron Kelly,
\nGeneral Manager
\nSQL Server<\/p>\n

For more information:<\/p>\n