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.
Thanks for your suggestion. We are looking into this scenario for a future release. 10697016
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.