Scale multiple Azure SQL databases on a logical server
Published Mar 13 2023 07:22 AM 2,488 Views
Microsoft

In a few scenarios, you might need to scale multiple databases on a logical server (not part of elastic pool) at once, the azure portal only allows you to scale each database individually. This can be achieved using the following PowerShell script:

 

just modify the parameters like SubID, the resource group and server name and then pick the service tier you want and run the script:

 

Connect-AzAccount
Set-AzContext -SubscriptionId "SubID"

$ResourceGroup = "ResourceGroup"
$Server = "SQLServer"
$edition = "Standard"
$ServObjective = "S2"

$Databases = Get-AzSqlDatabase -ResourceGroupName $ResourceGroup -ServerName $Server | Where-Object {$_.DatabaseName -ne "master"} | Select-Object -Property DatabaseName

foreach($DB in $Databases){ 
Set-AzSqlDatabase -ResourceGroupName $ResourceGroup -DatabaseName $DB.DatabaseName -ServerName $Server -Edition $edition -RequestedServiceObjectiveName $ServObjective}

 

Note: Be careful with the databases who are part of Geo replication or Failover groups as you need to make sure that the target database is upgraded before the source database.

Any database can be excluded like the master DB above, just add: | Where-Object {$_.DatabaseName -ne "DB name"}

 

References

Get-AzSqlDatabase (Az.Sql) | Microsoft Learn

Set-AzSqlDatabase (Az.Sql) | Microsoft Learn

 

Disclaimer
Please note that the products and options presented in this article are subject to change. This article shows how to multiple Azure SQL databases under single server at once in March 2023.

 

I hope this article was helpful for you. please feel free to share your feedback in the comments section below. 

 

 

Co-Authors
Version history
Last update:
‎Mar 13 2023 07:14 AM
Updated by: