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.

You asked ! We heard ! - HP Enterprise Data Warehouse (V 1.4) optimized for Microsoft PDW (AU3.5)

You asked ! We heard ! - HP Enterprise Data Warehouse (V 1.4) optimized for SQL Parallel Data Warehouse Software (AU3.5)

 

Hi everyone, I thought I would let you know about some new features which will be available with the HP Enterprise Data Warehouse (EDW Version 1.4). As many of you know, HP and Microsoft have partnered to provide the industry with the industry leading massively parallel SQL Server platform. The HP EDW appliance has been optimized and enhanced to support Microsoft SQL Server Parallel Data Warehouse Software (version AU3.5).

 

It should be noted that Hadoop connectivity is available to support unstructured and semi-structured “big data” requirements.  Structured data may be loaded into the EDW appliance using output from Hadoop Mapreduce or by using ETL software.

 

I personally, prefer systems which can scale-out because they allow the ability to start small using ½ a data rack with 4 active compute nodes and grow to 40 active compute nodes in 4 data racks. The feature of providing close to linear scalability up to 480 active cores is useful to support most customers’ ever increasing workload and data volumes. The EDW is ideal for supporting structured big data requirements up to 610 TB.

 

I also feel that end users will be happier with the HP EDW (V 1.4) appliance because of improvements in query response times and query throughput. In general, I would expect up to 2x performance gains for queries which tend to be CPU intensive and memory bound. Performance gains are a result of:

 

  • Intel Core Microarchitecture Sandy Bridge processors used in HP ProLiant Gen 8 servers

http://h20000.www2.hp.com/bc/docs/support/SupportManual/c03227849/c03227849.pdf

 

  • More memory per compute node (128GB in V1.4  vs. 64GB in V1.3 per Compute node)
  • Faster memory in each server
  • Larger tempdb space
  • FDR Infiniband
  • AU3.5 software more effectively taking advantage of Proliant Gen8 processor cores by exploiting NUMA technology to a greater degree
  •  Etc. 

It should also be noted that the new HP ProLiant Gen8 technology will help lay foundation for a better managed appliance. Speaking of an easier to manage appliance, HP is the only company who provides a comprehensive EDW Support Pack Utility Suite, which includes the following tools:

 

  • Firmware and Driver Validator
  • Firmware and Driver Updater
  • Hardware Diagnostics
  • Device Password Update Utility
  • EDW reports

 

The above tools make it easier to manage and maintain the HP EDW appliance running the Microsoft Parallel Data Warehouse (PDW) software.

 

Finally, HP and Microsoft have simplified field upgrades for existing EDW customers by using HP’s Factory Express and HP/Microsoft Installation services.

 

Find out further details about the solution at the following link.

Comments
PC Support(anon) | ‎09-25-2012 10:21 AM

thanks for the informative blog post!!

benslinkard(anon) | ‎09-27-2012 12:41 PM

Companies commonly use <a href="http://www.rizecorp.com/datawarehousingtechnologies.html"> Data warehousing </a> to analyze trends over time.

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
About the Author
Jeff Spiller has over 30 years experience in architecting highly available and scalable multi-tier platforms for a variety of Fortune 500 co...


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