Scaling SQL Elastic Pools

There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure portal and Azure PowerShell but not T-SQL.

I would say the PowerShell route is the easiest. Connect to your account and issue the below code. Here I am going from a 100 edtu pool to a massive 2000 edtu pool whilst tweaking the min/max setting.



Below shows the current spec of my elastic pool.

Get-AzSqlElasticPool -ResourceGroupName "AKS_PROD" -ServerName "smarties"



Use Set-AzSqlElasticPool to make the changes to whatever you desire.

Set-AzSqlElasticPool -ResourceGroupName "AKS_PROD" -ServerName "smarties" -ElasticPoolName "jumbo" -Dtu 2000 -DatabaseDtuMax 100 -DatabaseDtuMin 20

While the update is happening connect to the server via SSMS and you can check the progress.

SELECT * FROM sys.dm_operation_status
WHERE state_desc = 'IN_PROGRESS'


Get-AzSqlElasticPool -ResourceGroupName "AKS_PROD" -ServerName "smarties"



Then a final confirmation of the update.


6 thoughts on “Scaling SQL Elastic Pools

      • This means we do not have anything yet to auto scale the elastic pool service tiers, I need to write the powershell script ?


      • When I say out the box I mean there is nothing behind the scenes that will dynamically grow or shrink the pool based on usage. So if you know you need to increase eDTUs run PowerShell, Azure CLI whatever you like. thanks


  1. Hi, thanks for the immediate reply.

    When I say auto scaling of service tier, it means changing levels like (P0,P1,S0,S1 etc) and not scaling the EDTU’s. Am able to scale the edtu’s but not able to change the service tier automatically.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s