DTU and vCore differnces when to use DTU and When to user vCore

siva 46 Reputation points
2022-10-14T06:59:30.78+00:00

Hi Team

When to use DTU and When to use vCore

Azure SQL Database
Managed Instance

what are common differences.

Thanks

Azure SQL Database
{count} vote

2 answers

Sort by: Most helpful
  1. Bjoern Peters 8,921 Reputation points
    2022-10-14T14:27:09.443+00:00

    Hi @siva

    DTUs are only available for Azure SQL Database and NOT for Azure SQL MI.

    A typical answer would be, "it depends" ;-)

    DTU is the "old" option to select a performance class which is a mixture of CPU, RAM, IOPS
    vCore is the "new" option as many customers complained about DTUs - how is this calculated, and we cannot compare it to on-premise vCores...

    So it is just your decision what you like (and understand) more than a real technical decision.
    Start with a DTU database and test your application, then change to a vCore database and test your application, then make your decision...

    If you just need a database, go with Azure SQL database; if you want to take more activities and have more options for configuring your database, then go with an MI.

    And also take into consideration what Alberto said.

    6 people found this answer helpful.
    0 comments No comments

  2. Alberto Morillo 34,676 Reputation points MVP Volunteer Moderator
    2022-10-14T12:35:07.403+00:00

    Azure SQL DTU-model ties the Storage and Compute together, and no licensing fees exist, you don't need Software Assurance to reduce costs. For IO intensive workloads choose Premium tiers and not Standard tiers.

    With Azure vCore model you can scale Storage and Compute independently of each other. The vCore based model has several benefits when it comes to licensing if you have Software Assurance. The vCore model offers you Azure SQL Serverless, that is the only Azure SQL flavor that has auto-pause/auto-resume and is billed to the minute instead of hourly and is ideal for Dev/Test environments.

    When you are coming from a traditional SQL Server backend, Azure SQL Managed instance offers you the greatest compatibility with Microsoft SQL Server among all Azure SQL PaaS offerings. Azure SQL Managed Instance offers SQL Server native backups, SQL Server agent, cross database queries, replication to Always On environments and is almost 100% compatible with SQL Server with some exceptions explained here.

    For existing applications using SQL Server, Azure SQL Managed Instance makes more sense. For new modern applications and serverless applications, Azure SQL makes more sense.

    Finally this documentation gives you a brief comparison of all Azure SQL family of services.

    5 people found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.