Converged Infrastructure

You asked! We heard! HP Enterprise Data Warehouse is now optimized for SQL PDW Software

By Jeff Spiller - HP HP Enterprise Data Warehouse / Parallel Data Warehouse Technical Lead


HP Enterprise Data Warehouse Appliance (EDW Version 1.4) has some great customer requested improvements. As many of you know, HP and Microsoft have partnered to provide customers with an 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 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.


Personally I 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 HP EDW Appliance is ideal for supporting structured big data requirements up to 610 TB.


I feel end users will be happier with the HP EDW Appliance (V 1.4) 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 (see the HP Technology Brief titled Innovative technologies in HP ProLiant Gen8 servers)
  • 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

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


  • Firmware and Driver Validator
  • Firmware and Driver Updater
  • Hardware Diagnostics
  • Device Password Update Utility
  • HP 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 HP EDW customers by using HP’s Factory Express and HP/Microsoft Installation services.


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

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.
About the Author
About the Author(s)
  • 25+ years experience around HP Storage. The go-to guy for news and views on all things storage..
  • Technology marketing professional with over 25 years of experience in energy, semiconductor and IT industries.
  • More than 25 years in the IT industry developing and managing marketing programs. Focused in emerging technologies like Virtualization, cloud and big data.
  • More than 25 years of enterprise and midmarket Strategy and Marketing leadership and experience. Prior HP appointments included VP of Marketing for Adaptive Infrastructure and VP of Marketing for the HP Storage Division. Past positions prior to HP include VP of Marketing and Business Development for First Virtual Communications as well as Principal and Founding Member of Adjunct Consulting.
  • Over 12 years of consulting, new technology services development and marketing experience covering data center, IT infrastructure, cloud technology domains. Hande holds a M.B.A degree from Bentley College, MA.
  • More than 25 years in the IT industry, managing ITSM, service development and delivery projects in Technology Services. Specialized in end2end support for ISV based business solutions. Certified ITIL and project management expert.
  • Hector has marketing and communications expertise. With vast experience within the Enterprise Digital Marketing communications team at HP.
  • Editor and writer with 12+ years experience in the corporate software and technology sectors.
  • Marketing & communications professional with over 15 years of experience in a variety of industries across multiple continents. Part of HP Financial Services - helping customers build IT investment strategies that support tranformation and the ability to deliver business goals.
  • Eduardo Zepeda, WW TS Social Media Program Manager & Internal Communications for WW Technology Services Blogging on behalf of HP Technology Services (TS_Guest)
  • Julia Mason-Ochinero is WW CME Marketing Lead, HP Enterprise Marketing. In this role, Julia is responsible for driving dialog with CSPs on how they can transition to sustainable, profitable business models and enter into co-opetition with over-the-top (OTT) content providers who are changing this industry’s landscape. She joined HP in 2010 from Accel Partners (where she worked as a consultant.) Prior to Accel, Julia held marketing leadership positions with companies including Adobe, Nuance, OpenWave, Novell, Nuance Communications and RealNetworks. She began her career in Chicago working with organizations including AT Kearney, Andersen Consulting and Ameritech. She currently resides in Silicon Valley.
  • Focused on cloud, virtualization and appliance solutions for HP technology.
  • Hello! I am a social media manager for servers, so my posts will be geared towards HP server-related news & info.
  • HP Servers, Converged Infrastructure, Converged Systems and ExpertOne
  • More than 23 years of enterprise IT Marketing and Communications experience; working on the HP Converged Infrastructure Marketing team from when it was first pioneered and launched to the market in 2009.
  • Greetings! I am on the HP Enterprise Group marketing team. Topics I am interested in include Converged Infrastructure, Converged Systems and Management, and HP BladeSystem.
  • Teri is responsible for the social media program for the HP Networking and HP Storage business units. Teri has has held global roles in IT, Operations, Sales, Partner Programs, Communications, and Marketing at HP.

Follow Us