Change SQL Elastic Pool Setting

Question

Hello,

There are downtime when we increase the elastic pool DTU and Data Max Size?

Answer 1

Hey there Handian Sudianto

Thats a good question and thanks for using QandA platform

I guess yes, there can be downtime, but it depends on the specific changes you're making and your configs.

Usually increasing the DTU generally doesn't require downtime because it's a measure of the performance level, and Azure SQL Database can dynamically adjust resources based on demand. even if there is a downtime it will be very breif.

On the other hand, increasing the Data Max Size, can potentially cause downtime if the new size exceeds the current provisioned capacity. This is because Azure SQL Database might need to perform storage operations to accommodate the increased size,

Follow this upgrade during an non peak time and I suggest you to do that, to experience lesser downtime.

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql

If this helps kindly accept the answer thanks much.

Answer 2

@Handian Sudianto

Thank you for reaching out

My understanding is that you are asking about the potential downtime when scaling the DTU or adjusting the max data size of an Azure SQL Elastic Pool.

I would add in addition to Azar's answer.

Scaling DTUs or vCores

• This switch can result in a brief service interruption when databases are unavailable, generally lasting less than 30 seconds and often only a few seconds.
• No data loss

Changing Elastic Pool data Size:

• When you increase the max data size of the elastic pool. There will be downtime because the application would need to reconnect.

This article provides more detailed information.

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-scale?view=azuresql&tabs=azure-portal

https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-scale?view=azuresql&tabs=azure-portal#impact-of-changing-service-tier-or-rescaling-compute-size

In summary, while there may be a brief interruption during certain scaling operations, it is generally minimal and well within acceptable limits. Your applications should experience minimal impact when adjusting DTUs, vCores, or storage size in an Azure SQL Elastic Pool.

Regards,

Oury