Change Pricing Tier of SQL Database

Handian Sudianto 3,876 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 No comments
{count} votes

Accepted answer
  1. Alberto Morillo 32,711 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 No comments

1 additional answer

Sort by: Most helpful
  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 No comments