How To Rapidly Change Azure SQL Database Service Stage Aims
Typically as a DBA, I’m lazy and need the power to execute all of my duties in a single place. Fortunate for me I found the opposite day that I can change my Azure SQL Database Service Stage Object choices inside SQL Server Administration Studio (SSMS) with out ever having to go to the Azure Portal. By proper clicking in your database properties and selecting the Configure SQL web page you’ll be able to change your Subscription and Azure Location. Much more and what’s actually cool is I also can scale up and down my Version (which is usually known as Service Tier outdoors of SSMS), Dimension and Storage Tiers as effectively.
You’ll have to authenticate to Azure the primary time you employ this.
As soon as authenticated you will note the under choices obtainable.
Relying in your Service Tier corresponding to Fundamental or Premium, or the extra present Normal Function or Enterprise Crucial, you will have chosen your drop will dynamically change for every possibility. As you’ll be able to see within the instance above it’s presently set to Premium, thus I might see solely the “P” degree targets (compute and reminiscence ranges). Nonetheless, if I modified my Editions to anything my Service Stage Goal would change accordingly. Azure modifications regularly as do the choices. SSMS is making a name to the SQL useful resource supplier in Azure to get the choices, so it ought to all the time be present, although it might look totally different than this screenshot. For those who discover that the choice, you need it not within the dropdown they’ve given you the power to easily kind the worth.
The Max Dimension will can help you see your present dataset most storage dimension or scale it up and down when wanted. Leaving it clean will set it to the default dimension for the version and repair degree goal.
By clicking okay these modifications shall be implement and make take a slight downtime (must be minimal) occasion so watch out. One other factor price noting is permissions to change a database per ms docs a login have to be both,
- the server-level principal login
- a member of the dbmanager database function in grasp
- a member of the db_owner database function within the present database, or dbo of the database
In case you are GUI averse, you too can script these modifications out to T-SQL and run these. For instance, this script modifications the Service Stage Goal (SLO) to a Premium P2.
- ALTER DATABASE [YOUR DATABASE] MODIFY (SERVICE_OBJECTIVE = ‘P2’);
As soon as once more Microsoft has catered to lazy DBAs like me that need the whole lot in a single place. That is one other a type of issues I’m grateful to have the power to do in SSMS.