Scaling SQL Elastic Pools

Posted on by

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.

Connect-AzAccount

ignin

Below shows the current spec of my elastic pool.

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

 

currentspec

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'

inprogress

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

  

scaleup

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 ?

        Like

      • 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

        Like

  2. 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.

    Thanks,

    Like

    Reply ↓

Leave a Reply