How can we improve Microsoft Azure SQL Data Warehouse ?

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

42 votes
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)

We’ll send you updates on this idea

Kapil Jain shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • dwanalytics commented  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base