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.

27 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous 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