Share via

Change Pricing Tier of SQL Database

Handian Sudianto 4,511 Reputation points
2023-01-19T03:49:21.8966667+00:00

Hi..

if i want change pricing tier for SQL database let say from General Purpose to Hyperscale or from DTU model to vCore model, are this changed will have impact to the production such as downtime?

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 33,426 Reputation points MVP
    2023-01-19T04:14:38.1633333+00:00

    Depending on the size of the database and the operations and transactions is doing a the time of the change of tier, the scale up/down of the service tier may range from a couple of minutes to a little more than one hour. For example, 750 GB database may usually take 30 minutes of "downtime" until the change of tier is completed.

    Transactions opened at the time the change of tier is started, they will be rolled back, and logins will be disconnected. Contained database users will stay connected.

    Query plans may vary after scaling up/down because the number of threads available for query changes, and the data cache and query cache will be cleared.

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Avinash Mamidi 95 Reputation points
    2023-01-19T04:12:35.35+00:00

    There won't be any downtime when you are changing the Pricing tier of Azure SQL database. Please find the below URL for the steps required to change the pricing tier of Azure SQL.

    [https://www.c-sharpcorner.com/blogs/change-the-azure-sql-tier-using-sql-query

    0 comments