How can we improve Microsoft Azure SQL Data Warehouse ?

Implementing elastic pools for Azure SQL Data Warehouse

A customer asked if there are plans to implement some sort of elastic pools where you can include many data warehouses and share DWU (eDWU?) the same way elastic database pools work with SQL Databases.

29 votes
Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)

We’ll send you updates on this idea

Diego Caracciolo shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
under review  ·  AdminSQL DW Team (Feedback, Microsoft Azure) responded  · 

Thank you for all the feedback folks. This is on our radar and we will consider this in a future release. We will reach back out when it is on the roadmap and can share when we have an update. Please vote for this feature and comment on your scenario below.

5 comments

Sign in
(thinking…)
Sign in with: Microsoft
Signed in as (Sign out)
Submitting...
  • John commented  ·   ·  Flag as inappropriate

    This would be excellent for multi-tenant reporting solutions. Currently, DWUs are assigned per-Data Warehouse. We want to pool this resource across multiple data warehouses.

  • Mark commented  ·   ·  Flag as inappropriate

    This would be of great value for our multiple dev/test environments.

  • laura edell commented  ·   ·  Flag as inappropriate

    Something like elastic pools for DW to share the resource burden would be huge. This is an ask for the #1 consumer of Azure as of 2017.

  • Se Hee Lee commented  ·   ·  Flag as inappropriate

    The idea of having DWU per database is great, but why stop there?

    Why can't you allow the DWU at the farm level?

    Farm can be made of many databases, and you can control the DWU for all.

    For service provider such as us, we can have a separate database per our customers while enjoying a same DWU across all.

    This spreads the cost down drastically for us as not all customers are using the database extensively.

Feedback and Knowledge Base