Microsoft 400x400

Microsoft Parallel Data Warehouse Review
Gives us the ability to distribute large data sets across nodes.

Valuable Features

MPP processing gives us the ability to distribute large data sets across nodes.

Improvements to My Organization

We delivered a data warehouse for Contactless and Oyster at TFL.

Room for Improvement

Improve the speed of processing replicated tables.

Use of Solution

We have been using this solution for years.

Stability Issues

There were stability issues when the product was in beta.

Scalability Issues

There were scalability issues in that there is a limit to 32 concurrent queries.

Customer Service and Technical Support

Technical support is good.

Previous Solutions

We switched from the standard SQL server 2014. We use PDW to improve overall ETL and report performance.

Initial Setup

The initial setup was complex. It was fairly challenging to migrate from SQL server to PDW.

Other Advice

Make sure your data volumes are very large: At least 60 million rows per table.

Disclosure: I am a real user, and this review is based on my own experience and opinions.

Add a Comment

Anonymous avatar x30
Why do you like it?

Sign Up with Email