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

Jeremy 0 Reputation points
2024-02-20T04:35:57.5033333+00:00

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
{count} votes

3 answers

Sort by: Most helpful
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2024-02-20T05:21:15.91+00:00
    0 comments No comments

  2. 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:

    User's image

    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

    0 comments No comments

  3. 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!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.