Is there downtime while Scaling Azure SQL Elastic Pool Storage?

2.7k views Asked by At

I have an Azure SQL Elastic Pool with 800 eDTUs and 400GB of Storage.

In past, I used to have 400 eDTUs, and when I scale to 800 eDTUs I had a small downtime in the website (~15-30 seconds), so before making any changes to the storage, I'd like to check if I should expect downtime as well.

Does anyone know?

2

There are 2 answers

0
Sajeetharan On BEST ANSWER

I don't think don't need downtime when you Increase DTU's. Definitely, there is certain impact which you can read from here

Regardless, the switch can result in a brief service interruption when databases are unavailable generally for less than 30 seconds and often for only a few seconds

2
Prasun On

We do scaling real-time in eDTU's and DTU's and no downtime observed. URL :https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources

enter image description here