How can we improve Microsoft Azure SQL Data Warehouse ?

Provide a way to expose the actual DWU usage (not the same as the scale setting).

You can see what the database is scaled to i.e. DWU 200, but how do you know how much is actually being used over time. The portal display a graph of both the DWU limit and the DWU used but there is no way to programmatically monitor how much is being used.

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

We’ll send you updates on this idea

Elliott Oedewaldt shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
need-feedback  ·  AdminSQL DW Team (Feedback, Microsoft Azure) responded  · 

We are actively improving our monitoring experience. Currently we have ‘DWU Used’ in the portal which is a blend between CPU and IO to indicate data warehouse utilization. We also have future improvements on our road map such as Query Data Store and integrating with Azure Monitor for near real time troubleshooting in the Azure portal. If anyone has any other feedback, please elaborate on your scenario on this thread. Thank you for your continued support!

1 comment

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

    This is a important feature that most of the teams looking for. We need a way to find the top SQLs that are consuming heavy resources(in terms of DWU)- which helps the team in-turn to take appropriate action on the queries/tables.

Feedback and Knowledge Base