Is there any downtime when increasing the Azure SQL Database storage?

Question

We are about to increase the database storage of our client, but it is currently on hold since the client wants to know if there is any downtime.

Answer 1

Similar thread : https://stackoverflow.com/questions/26528475/changing-service-tiers-or-performance-level-and-database-downtime

Answer 2

Hi
Jeremy,

Welcome to Microsoft Q&A forum.

As I understand, you want to know about the downtime for increasing Azure SQL Database storage.

The estimated latency to change the service tier, scale the compute size of a single database or elastic pool, move a database in/out of an elastic pool, or move a database between elastic pools is parameterized as follows:

Note:

• Additionally, for Standard (S2-S12) and General Purpose databases, latency for moving a database in/out of an elastic pool or between elastic pools will be proportional to database size if the database is using Premium File Share (PFS) storage.
• In the case of moving a database to/from an elastic pool, only the space used by the database impacts the latency, not the space used by the elastic pool.
• To determine if a database is using PFS storage, execute the following query in the context of the database. If the value in the AccountType column is PremiumFileStorage or PremiumFileStorage-ZRS, the database is using PFS storage.

Refer https://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-scale?view=azuresql&tabs=azure-portal for more details.

Hope this helps. Let us know if you have further queries.

Thanks

Answer 3

Hi Jeremy, Usually, there isn't a specific downtime required for this operation, but it's preferable to do it when database activity is low or during non-business hours to prevent any disruptions. Thank you!