Change Pricing Tier of SQL Database

Question

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?

Answer 1

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.

Answer 2

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