Technical Support Services Blog
Discover the latest trends in technology, and the technical issues customers are overcoming with the aid of HP Technology Services.

HP AppSystem for Microsoft SQL Server 2012 Parallel Data Warehouse: What's all the noise?

by Kevin Lange, Master Database Architect


When it comes to Parallel Data Warehouse (PDW), the 1st order of business has always been blazing compute and IO performance.  PDW has been synonymous with speed since the initial integration with Data Allegro, v2.0 pushes that envelope with updatable column store indices.  A column store index stores data in [horizontal] columnar format, allowing for much more of the index read data to the stored on the same 8k page; SQL data is read in these 8k chunks, less reads more data.  With Columnar indices,  only the data actually required to satisfy the query is transferred from disk to memory [not the data of other columns like with traditional indices, disk pages containing the other columns data are simply ignored]. In doing so, the number of pages transferred from disk to SQL memory is tremendously less.  v2.0 applies aggressive compression algorithms to further reduce the disk I/O needed to serve the query request and yield up to 50x gain in query performance.


Capacity is now increased to multiple petabytes per BI implementation, again due to increasing compression, as well as improved process and thread parallelization and process dispatch efficiencies.  6PB + capacity places a Parallel  Data Warehouse in the sweet spot of enterprise class BI data operations, right out of the box, with the familiar HP SQL Server services  [which include; Database Consolidation Reference Architecture, Enterprise Data Warehouse, Fast Track Services, Oracle to SQL Server Migrations, Performance Tuning and High Availability Clustering and BI Workshops and Implementation Services] and tool set [SQL Server Analysis Services, Integration Services, Reporting Services, Master Data Services and Data Quality Services].


Extensibility stems from the integration PDW2.0 now has with non-structured data stores [like Hadoop].  A data interoperation technology coined PolyBase, provides a unification layer between [Hadoop Cluster] MapReduce calls and traditional SQL calls.  Simply put, a BI developer can now write a connected SQL query that can access a non-relational Hadoop data structure and retrieve that data, mapped to a tabular format.  Even more exciting is the fact that PolyBase allows for joining existing SQL Server based relational tables to the mapped non-relational data, in effect integrating both realms of customer information.


Finally, Total Cost of Ownership; TCO has always been a mainstay of value for SQL Server deployments.  In a study published with the V2.0 release; EMC, IBM, Microsoft, Teradata, and Oracle Data Warehouse deployments were independently compared for capacity and speed, both pivoted against equivalent price.  The bottom line, HP PDW V2.0, substantially outperformed the competition.  SQL Server's $5 per TB of data was almost half the cost of the nearest competitor.


PDW V2.0 is indeed a game changer which is generating significant industry buzz, as the final production bits are being shipped.


As someone who has been around data management for some time, I can say that PDW V2.0 is a great product.  As good as the product is, customers should know that their support experience with PDW will be a great because HP delivers the services that drive performance.   From our Assessment, to ensure that  the  system is planned and well-sized,  to our Deployment Accelerator and Advisory services, to ensure that we have a  smooth transition  into production  -   our HP/Microsoft unified approach  to Appsystem support for PDW, ensures that issues are resolved quickly and without any confusion.


For more information, please visit our website @  HP AppSystem for Parallel Data Warehouse.




Kevin Lange is a Master Database Architect, and has over 27 years in enterprise information systems.  Kevin has a developer's passion, with skills spanning traditional client-server architecture, virtualized and cloud/web-enabled deployments, application development and  IT infrastructure, and database design, architecture and deployment.

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)
  • I graduated in Software Engineering. Joined HP family five years ago, I deliver Insight Remote Support technical consulting for HP customers, in North America, Canada and Latin America. Assist setting up, installing and configuring the solution in customers' IT environments.
  • I am an identical twin. My brother’s name is Greg Tinker and we have been extremely fortunate working similar careers within HP, known to our HP colleagues and many of our customers as "The Tinkers". Our job is to be the technical lead on major business operational outages with millions of Dollars/Euros hanging in the balance. We both have a complete background in architectural, Infrastructure and application environments from both the proactive and reactive side of HP Enterprise Service (HP ES), and HP Enterprise Business (HP EB).
  • I am an identical twin. My brother’s name is Chris Tinker and we have been extremely fortunate working similar careers within HP, known to our HP colleagues and many of our customers as "The Tinkers". Our job is to be the technical lead on major business operational outages with millions of Dollars/Euros hanging in the balance. We both have a complete background in architectural, Infrastructure and application environments from both the proactive and reactive side of HP Enterprise Service (HP ES), and HP Enterprise Business (HP EB). We have always attended the same schools, studied the same material (big surprise, as we are identical twins), and have always worked as a close team and strive to demonstrate our teaming ability’s to others. We each have more than 11 years experience supporting mission-critical enterprise customers on a broad range of technologies. We’ve both won the HP MVP award multiple times as well as coauthored books, programs, and whitepapers in our spare time.
  • 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.
  • Eduardo Zepeda, WW TS Social Media Program Manager & Internal Communications for WW Technology Services Blogging on behalf of HP Technology Services (TS_Guest)
  • I have been with HP for 13 years, always in Services - first as a Services Channel Sales rep, then a Channel Services Segment Manager, and now, in WW Technology Services Marketing. These may be my formal job titles, but I'm really a Cheerleader for HP Services! I feel that HP has great services, exceptional Technical Experts and Delivery teams, and so many cool things are going on at HP Services. So, stay tuned...
  • Mr_T? Yes, but in name only. No mohawk or gold chains. In real life I'm Jim Turner, a Master Technologist with HP's Integration and Technical Services team. I leverage my 27 years of system, storage, and networking experience to ensure optimal performance with Data Protector and StoreOnce technologies. Many times the source of a problem is not where it appears to be. A broader view of the landscape and a deeper knowledge of system internals are frequently required, and that's precisely what I deliver.
  • MrCollaboration (aka Jim Evans) is an HP Global Services Alliance Manager. He has worked in the IT industry for more than 30 years, 22 of which were spent with Digital Equipment Corporation, Compaq and HP. He works with many third party vendors and partners to develop processes to facilitate excellent support and service for mutual customers. Jim is also HP’s representative to the Technical Support Alliance Network (TSANet).
  • I've been working in Customer Service for over 20 years. During my career I've provided support services for Languages, Programming Libraries and Operating Systems. During the last 10 years I've provide support for Linux and more recently VMware. My current role is as a Technical Account Manager working in the HP Custom Mission Critical Services Industry Standard Operating Systems team. I provide both reactive and proactive operating system support for proLiant servers and blades. Our services in the Custom teams are built on statement of work contracts for large HP customers who need a customized mission critical support offering.
  • I've been working in HP since 2007 like IT agent, developer, Web designer and then like Web Project Manager
  • I like to listen as much as I like to talk. Why? My 25+ years in the technology industry has taught me that the key to delivering value to customers is to understand what they value in the first place! I developed this passion for customers and consultative selling during my 12 years with Accenture, and I have continued to approach customers in a consultative way during my 12+ year tenure with HP. I also have a passion for HP given my knowledge of our Product and Service Portfolio and the differentiators we possess that position us as a leader in the areas our customers are telling us they want to go. Converged Infrastructure, Converged Cloud, Big Data – and the associated Service and Support implications – all such exciting technology trends where our success will hinge upon our ability to differentiate ourselves versus others in the areas that matter most to our customers. Right up my alley, and I am proud to be part of the great HP team where I know we have the best solutions in the industry!
  • Tom Clement has over 30 years experience in the areas of adult learning, secondary education, and leadership development. During this time Tom has been a consistent champion of “non-traditional” training delivery methods, including blended learning, virtual delivery (self paced and instructor led), the use of training games and simulations, and experiential learning. Tom has spent the past 25 years of his career at Hewlett Packard, focused most recently on HP’s global Virtualization, Cloud, and Converged Infrastructure customer training programs. Tom manages the strategic direction and overall performance of these training programs, ensuring these worldwide programs help HP’s customers capitalize on the business opportunities made available by IT advancements in each of these subject areas. Tom and his global teammates utilize best in class instructors, course content and supporting equipment infrastructure to deliver these training programs to HP’s customers. The team prides itself on providing the Virtualization, Cloud, and Converged Infrastructure content customers need when and where they need it, anywhere in the world. Tom is based in the Washington, DC suburbs and can be reached at

Follow Us
Top Kudoed Posts