Rethink BI : Business Insights over Business Intelligence
The purpose of this business insights thought leadership blog is to share the HP point of view on industry trends such as Big Data and Real Time Analytics, and provide updates on key innovations and solutions.

HP ProLiant server platforms deliver top database performance with Microsoft SQL Server

By John Connors - HP Converged Systems Performance Engineering

 

With the demands presented by huge growth in data volumes, customers increasingly need database platforms which enable the rapid processing of highly complex database queries, in order to get timely answers to critical business questions. 

 

In order to understand a broad and complex playing field of competitive offerings, and to set strategic direction customers need some objective and verifiable way of measuring the differences between solutions.  For BI database environments, understanding overall system performance and system price/performance metrics can also help drive buying decisions.

 

The Transaction Processing Council provides this independent and consistent measurement with the TPC-H benchmark that reflects multiple aspects of the capability of a system to process queries. 

 

That’s why we’re delighted to have taken leadership in all three of the key TPC-H non-clustered benchmark categories, 1,000GB, 3,000GB, and 10,000GB, with the HP ProLiant DL980 G7 Server running Microsoft Windows and Microsoft SQL Server.

 

Central to the success of the solution in achieving such high benchmark figures were the following key innovations:

 

  • HP PREMA ArchitectureThe HP PREMA Architecture in the ProLiant DL980 G7 server leverages HP’s years of experience designing mission-critical servers in RISC, EPIC, and UNIX environments and applies that knowledge and expertise to its design of the server. As a result, the DL980 G7, using glued node controller architecture with Smart CPU caching, provides significant scaling and resiliency benefits over glue-less 8-socket systems.

 

  • HP Smart CPU caching - Each node controller of the DL980 G7 stores information about all data located in the processor caches. This HP-only technology minimizes inter-processor cache coherency communication, reduces memory latencies, and enables more net I/O bandwidth.

 

  • HP Smart Array ControllerThe DL980 G7 ran with the efficient HP Smart Array P421 Controller and HP driver, which allowed a low overhead in high bandwidth environments, resulting in a higher performance advantage. HP Smart Array Controllers are ONLY available with HP servers

 

  • Microsoft SQL Server - Features SQL Server AlwaysOn for mission critical availability along with xVelocity in-memory technology for fast DW and BI query performance. Customers will also be able to quickly unlock business insights within billions of rows of data with PowerPivot for Excel and Sharepoint and Power View allows for rich interactive data visualizations and presentation experience for all users.  

 

Some of the highlights of the benchmarks were as follows:

 

  • HP delivered 2X the performance of the previous 10,000GB leadership number at 34% of the cost
  • Leadership across three scale factor levels -- 1000GB, 3000GB, and 10000GB
  • Almost 2 years of unchallenged leadership at 1000GB and 3000GB levels

To find out more, please download the detailed benchmark report here, and please contact us to find out how HP can deliver the optimal data management solution for your business.

 

 

Please note

 

TPC and TPC-H are trademarks of the Transaction Processing Performance Council. TPC-H results show the HP ProLiant DL980 G7 with a result of 158,108.3QphH @10000GB and $6.49/QphH @ 10000GB with system availability as of August 11, 2011; a result of 219,888 QphH @ 1000GB and $1.86/QphH @ 1000GB; and a result of 162,601 QphH @ 3000GB and $2.68/QphH @ 3000GB. These benchmark results are as of April 15, 2013.

 

Visit Transaction Processing Council for up-to-date information and disclaimer information

Leave a Comment

We encourage you to share your comments on this post. Comments are moderated and will be reviewed
and posted as promptly as possible during regular business hours

To ensure your comment is published, be sure to follow the community guidelines.

Be sure to enter a unique name. You can't reuse a name that's already in use.
Be sure to enter a unique email address. You can't reuse an email address that's already in use.
Type the characters you see in the picture above.Type the words you hear.
Search
Showing results for 
Search instead for 
Do you mean 
About the Author
Featured


Follow Us
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.