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


What is most valuable?

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

How has it helped my organization?

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

What needs improvement?

Improve the speed of processing replicated tables.

For how long have I used the solution?

We have been using this solution for years.

What do I think about the stability of the solution?

There were stability issues when the product was in beta.

What do I think about the scalability of the solution?

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

How is customer service and technical support?

Technical support is good.

Which solutions did we use previously?

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

How was the initial setup?

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

What other advice do I have?

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

Guest
Why do you like it?

Sign Up with Email