PowerShell script to help migrate from DTU to vCore model of Azure SQL DB.
Published Feb 03 2022 10:44 AM 4,218 Views



There are two billing models for Azure SQL Database (SQL DB); the Database Transaction Unit (DTU) model, which is a blended measure of CPU, memory and IOPS, and the vCore model that allows you to choose the number of virtual CPUs you need. The vCore model also allows you to choose the generation of hardware and newer hardware types such as the M-series, FSv2-series and DC-series for confidential computing. The other advantage of the vCore model is the ability to bring your box product SQL Server licenses to Azure to reduce the running costs via the Azure Hybrid Benefit (AHUB).



Conversion from DTU to vCore


There is a simple approximation you can use to estimate the number of vCores from the number of DTUs;


              100 DTU in Basic or Standard tiers = 1 vCore in General Purpose tier

              125 DTU in Premium tier = 1 vCore in Business Critial tier


This article provides more details and a query to run on a SQL DB to provide an estimate.



Scaling to the Enterprise


The problem that many larger customers run into is that running a query across their estate of SQL DBs is the prohibitive amount of effort required.


Instead, we have written a PowerShell script that an Azure Subscription(s) contributor can use to both discover the DTU model SQL DBs and based on the configured number of DTUs it provides an estimate of the number of vCores you should use as the starting point for conversion to the vCore model.


Note that for SQL DBs in an elastic pool, the script estimates the size of the Elastic Pool in vCores instead of the number of vCores for that specific SQL DB.


The PowerShell script creates a comma separated values (CSV) file, for each of the subscriptions the account running the script has access to, with the properties of the discovered SQL DBs and the conversion estimate.


The PowerShell script can be downloaded from the Microsoft Download Center. For information related to support for this tool, please refer the license agreement that is included in the download. 



Feedback and suggestions


If you have feedback or suggestions for improving this data migration asset, please contact the Azure Databases SQL Customer Success Engineering Team. Thanks for your support!

Version history
Last update:
‎Jun 01 2023 01:25 PM
Updated by: