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.

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.

Leave a Reply

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

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s