Change Pricing Tier of SQL Database

asked 2023-01-19T03:49:21.8966667+00:00
Handian Sudianto 1,186 Reputation points

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

Accepted answer
  1. answered 2023-01-19T04:14:38.1633333+00:00
    Alberto Morillo 24,631 Reputation points Microsoft MVP

    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.

    No comments

1 additional answer

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

    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

    No comments