Thank you for voting for this feature. We understand this scenario and will consider this in a future release. For now, please continue monitoring this item and have your team vote for this feature. Thank you for your patience.
An error occurred while saving the commentdwanalytics commented
Couldn't agree more. It is great that I can check the scaled performance level of my data warehouses using a T-SQL query from the Microsoft SQL Azure master datebase:
SELECT db.name, ds.edition, ds.service_objective, db.state_desc
FROM sys.database_service_objectives ds
JOIN sys.databases db ON ds.database_id = db.database_id
WHERE ds.edition = 'DataWarehouse'
I can't believe this isn't already built in; but this query always reports the data warehouse as 'Online' even when it is really in a 'Paused' state.