In this article, we are going to talk about Azure SQL DTU to vCore Migration. I have already spoken about the advantages of moving to a vCore based pricing model on a different article. Generally, for customers who are just starting up with their online business, a DTU based deployment is the most cost-effective solution.
Azure SQL Hyperscale Tier
Over time, your application might need additional performance, and DTU models might not be sustainable. As a refresher, here is the calculation for vCores vs DTUs:
** A maximum of 4000 DTUs are support at the time of writing this article.
Migrating from SQL DTU based model to vCore is thankfully straightforward. The migration is in place and does not need a lot of downtimes. Moreover, the existing Azure SQL (logical server) can still host the databases under the vCore licensing mode. This means that there are no changes to the current connection string and no application changes are required.
What does change is the pricing tier and the fact that the “Hyperscale” does not allow you to come back to the DTU based service tier. With this in mind, follow the simple steps below to complete it:
That’s it! it takes less than a minute to complete the migration and you should be up and running shortly after. Here are some screenshots below for your reference:
As you can see from the example explained above, migration is easy and can be done anytime when you want to switch. Once you are fully aware of the performance benefits, we recommend going for it.
We hope our article was helpful with your Azure SQL DTU to vCore Migration plan. Your valuable feedback and suggestions are welcome in the comment box down below. Thanks for visiting!
Comments are closed.