SanDisk and Microsoft Data Center Solutions Series: TPC-H World Records, What do the Latest TPC-H World Record Benchmarks from Cisco, HPE, and Lenovo have in Common? SanDisk Flash

TPC benchmarks (found on tpc.org) are used in evaluating the performance of computer systems. Three of the latest TPC-H world record holders all use SanDisk flash.

Server vendors often promote TPC benchmark world records that have been set using their server hardware. Transaction Processing Performance Council (TPC) is a non-profit organization founded in 1988 to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry. TPC benchmarks are used in evaluating the performance of computer systems; the results are published on the TPC web site (tpc.org).

The TPC Benchmark™ H (TPC-H) is a decision support benchmark. It 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. TPC-H is a common benchmark used to compare systems that are used for data warehouse and business analytics solutions. And this now becomes relevant for enterprises looking at systems to power their SQL Server-based data platforms.

 

SQL Server® 2016 Benchmarks from Cisco and Lenovo

When SanDisk Server partners prepared their high performing, non-clustered systems for TPC-H benchmark testing, they turned to SanDisk and its Data Propulsion Labs (DPL). Focusing on SQL Server 2016, Lenovo and Cisco, working with SanDisk, provided best-in-class storage solutions to help them take top honors in the TPC-H benchmark. The leaders in the 3,000GB category and in the 30,000 GB Category all utilized Fusion ioMemory™ flash to achieve record-setting results.

These partners were able to increase the performance while reducing the Query-per-Hour (QphH) cost by up to one-third. They were able to do this, in many cases, by moving to and utilizing the dramatically improved performance of SQL Server 2016 on flash.

 

3,000 GB Results
Company Lenovo
System Lenovo System x 3850 x 6
QphH 969,504
Price/QphH .72 USD
Watts/KQphH NR
System Availability 07/31/16
Database Microsoft SQL Server 2016 Enterprise Edition
Operating System Microsoft Windows Server 2012 R2 Standard Edition
Data Submitted 03/09/16

 

In March 2016, Lenovo crushed the previous 3,000 GB, non-clustered record, achieving:

  • 35% higher QphH performance
  • 33% lower Price/QphH

Lenovo accomplished this utilizing their System x3850 data-center-focused server and six (6) 3.2TB Fusion ioMemory cards.

 

3,000 GB Results
Company Cisco
System Cisco UCS C460 M4 Server
QphH 1,071,018
Price/QphH .60 USD
Watts/KQphH NR
System Availability 06/01/16
Database Microsoft SQL Server 2016 Enterprise Edition
Operating System Microsoft Windows Server 2012 R2 Standard Edition
Data Submitted 05/14/16

 

Two months later, Cisco took the non-clustered performance lead while reducing the overall cost in the 3,000 GB category. Compared to the previous leader, their system achieved:

  • 10%+ higher QphH performance
  • 17% lower Price/QphH

The Cisco UCS C460 M4 Server utilized four (4) 1.6TB Fusion ioMemory cards in the configuration.

 

3,000 GB Results
Company Hewlett Packard Enterprise
System HPE ProLiant DL580 Gen9 Actian Vector 5.0
QphH 2,140,307
Price/QphH .38 USD
Watts/KQphH NR
System Availability 07/31/16
Database Actain Vector 5.0
Operating System Red Hat Enterprise Linux Server 7.2
Data Submitted 06/02/16

 

Don’t forget about HPE®

Using a Linux offering, Actian Vector 5.0, HPE significantly increased performance and further reduced costs in the 3,000GB category. While hard to compare to Microsoft SQL Server in features and overall enterprise data platform value, it did allow HPE to set a new TPC-H record. Compared to the previous leader, HPE achieved:

  • Double the QphH performance
  • 37% lower query cost (Price/QphH)

HPE relied on their rock-solid ProLiant DL580 Gen9 server with six (6) 3.2TB Fusion ioMemory cards from SanDisk.

 

3,000 GB Results
Company Lenovo
System Lenovo System x 3850 x 6
QphH 969,504
Price/QphH .72 USD
Watts/KQphH NR
System Availability 07/31/16
Database Microsoft SQL Server 2016 Enterprise Edition
Operating System Microsoft Windows Server 2012 R2 Standard Edition
Data Submitted 03/09/16

 

Blowing Away Big Data

Working with SanDisk’s DPL team, Lenovo built a single-server system with their high performing System x3950 and the Fusion ioMemory SX350 flash from SanDisk. The single-server system delivered a record-breaking 1 million QphH, the first time a database of this size (30TB) was able to perform at this level.

 

Performance You Can Rely On

Server vendors turn to SanDisk to deliver the highest-performing data warehouse and business intelligence systems in the industry. And you can see the results. If your SQL Server data platform is critical in powering your business, don’t settle. SanDisk flash solutions are proven and relied upon by the industry’s best. To learn more, visit www.sandisk.com.

READY TO FLASH FORWARD?

Whether you’re a Fortune 500 or five person startup, SanDisk has solutions that will help you get the most out of your infrastructure.

VIA
EMAIL

Go ahead, ask us some questions and we'll get back to you with answers.

Let's Talk
800.578.6007

Don't wait, let's just talk now and start building the perfect flash solution.

Global Contact

Find contact information for offices all over the world.

SALES INQUIRIES

Whether you'd like to ask a few initial questions or are ready to discuss a SanDisk solution tailored to your organizations's needs, the SanDisk sales team is standing by to help.

We're happy to answer your questions, so please fill out the form below so we can get started. If you need to talk to the sales team immediately, please phone: 800.578.6007

Field cannot be empty.
Field cannot be empty.
Enter a valid email address.
Field can only contain numbers.
Field cannot be empty.
Field cannot be empty.
Field cannot be empty.
Field cannot be empty.
Field cannot be empty.
Field cannot be empty.

Please indicate your areas of interest:

You must choose an option.

Questions or comments:

You must choose an option.

Thank you. We have received your request.