Scale Azure SQL DB
Scale Azure SQL DB from the command line.
Check current service tier
SELECT CAST(DATABASEPROPERTYEX(db_name(),'serviceobjective') AS NVARCHAR(50)) AS ServiceObjective
Scale service tier
Scale to S3:
ALTER DATABASE [Reporting]
MODIFY (
SERVICE_OBJECTIVE = 'S3'
);
The query returns immediately.
If the target database is already at the specified service tier, no change is made.
If scaling starts, at some point in the next few minutes, every live database connection will be disconnected (including this one – you can monitor the database property to see when the change takes place, but must do so from outside T-SQL, catching any disconnection errors for retry).