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.
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!
Aravind K commented
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.