Similar thread : https://stackoverflow.com/questions/26528475/changing-service-tiers-or-performance-level-and-database-downtime
Is there any downtime when increasing the Azure SQL Database storage?
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.
Azure SQL Database
3 answers
Sort by: Most helpful
-
Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
2024-02-20T05:21:15.91+00:00 -
SSingh-MSFT 16,371 Reputation points Moderator
2024-02-20T06:09:41.5366667+00:00 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
orPremiumFileStorage-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
-
RahulRandive 10,486 Reputation points Volunteer Moderator
2024-02-21T12:17:08.35+00:00 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!