Microsoft Parallel Data Warehouse Review

Concurrency issues forced the customer to use the raw DB as a secondary solution

What is our primary use case?

We are using PDW as an EDW solution.

How has it helped my organization?

It helped, initially, as a replacement for our DW DB, but later on faced issues due to concurrency, which forced the customer to use the DB as a secondary solution.

What is most valuable?

Nothing specific, comparable to other solutions.

What needs improvement?

Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.

They need to improve the metadata being captured to a greater duration.

For how long have I used the solution?

One to three years.
**Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment