Pause Resume Azure SQL Data Warehouse Using SQL Command
It would be great if we can have SQL command to Pause/Resume DB instance like how we do for Scale up/down (under Master DB). This will help us to manage the same from ADF and don't have to worry about trigger REST API or PowerShell
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.
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.