Is it possible to make azure elastic pool scale automatically?

Question

Is it possible to make azure elastic pool scale automatically?

Hang Heng 20

I was wondering on how to make azure elastic pool scale automatically?

For an example, from 06:00AM to 06:00PM, I would like to use SQL Elastic Pools's Pricing tire is Standard: 100eDTus and from 06:01PM to 05:59AM, I would like to use SQL Elastic Pools's Pricing tire is Standard: 50eDTus.

Please help, I am looking forward to hearing from all of you.

Thank you.

JimmySalian-2011 42,491 Reputation points

2023-07-26T10:14:13.7533333+00:00

Hi Hang,

AFAIK, I think this is not possible however there might be ways you can do it via third party tools by default as you can scale an elastic pool up or down dynamically based on actual experience.

Check the thread here for a powershell script - https://stackoverflow.com/questions/50813099/is-it-possible-to-make-azure-elastic-pool-scale-automatically
Hang Heng 20 Reputation points

2023-07-27T01:19:07.3366667+00:00

Thanks JimmySalian-2011
SSingh-MSFT 16,371 Reputation points Moderator

2023-07-27T11:00:28.8633333+00:00

Hi Hang Heng •,

Following up to see if the below suggestion by Community MVP @AlbertoMorillo was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Accepted answer

0 additional answers

Your answer

JimmySalian-2011 42,491 Reputation points

2023-07-26T10:14:13.7533333+00:00

Hi Hang,

AFAIK, I think this is not possible however there might be ways you can do it via third party tools by default as you can scale an elastic pool up or down dynamically based on actual experience.

Check the thread here for a powershell script - https://stackoverflow.com/questions/50813099/is-it-possible-to-make-azure-elastic-pool-scale-automatically
Hang Heng 20 Reputation points

2023-07-27T01:19:07.3366667+00:00

Thanks JimmySalian-2011
SSingh-MSFT 16,371 Reputation points Moderator

2023-07-27T11:00:28.8633333+00:00

Hi Hang Heng •,

Following up to see if the below suggestion by Community MVP @AlbertoMorillo was helpful. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

Yes, you can. You can schedule a PowerShell script using Azure Automation to scale up the eDTUs and another one to scale down the eDTUs, Below, you will find how to scale up or down using PowerShell:

# Scale the pool
$elasticPool = Set-AzSqlElasticPool -ResourceGroupName $resourceGroupName `
    -ServerName $serverName `
    -ElasticPoolName $poolName `
    -Edition "Standard" `
    -Dtu 100 `
    -DatabaseDtuMin 20 `
    -DatabaseDtuMax 100

To get started with Azure Automation, try this short training.

Hang Heng 20 Reputation points

2023-07-27T01:19:30.32+00:00

Thanks Alberto Morillo
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator

2023-07-27T04:23:44.77+00:00

You are welcome @Hang Heng

Share via

Is it possible to make azure elastic pool scale automatically?

0 additional answers

Your answer