Azure SQL ( Vcore to DTU Mapping )

Sid_1805 91 Reputation points
2022-02-04T12:35:50.547+00:00

Is there a Microsoft documentation which can claim 100 DTUs ¬ 1 Vcore.
I have seen that in few forums but when we want to do a price comparison with approx same compute & storage it makes it challenging.

Any leads?

Thanks!

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 32,791 Reputation points MVP
    2022-02-04T13:46:59.1+00:00

    In my opinion best way to compare them is identifying how many cores and storage are available on each service tier using the following query:

    SELECT * FROM sys.dm_user_db_resource_governance

    For example on eastus region:

    • Basic and S0 use one core.
    • S4 and S3 use 2 coress
    • S6 uses 3 cores
    • S7 can use 6 to 12 cores, depending og generation (G4/G5) and zone.
    • S9 uses 24 cores
    • S12 uses 44 cores
    • P1 uses one core with premium storage
    • P2 uses 4 cores
    • P6 uses 12 cores
    • P11 uses 18 cores
    • P15 uses 42.

    Take in consideration the slo_name column on the query results, that tells you the hardware generation. The query also returns the max storage. You need to run the query on each service tier to better know the compute power available on the region you are located.

    Now with that information you can use Azure SQL price calculator and compare vcore and DTU service tiers that have the same compute and storage.

    1 person found this answer helpful.

  2. Alan Kinane 16,781 Reputation points MVP
    2022-02-04T13:37:52.087+00:00

    It is not possible to do an exact comparison but that is the approximate rule of thumb recommended here - https://learn.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore

    171396-screenshot-2022-02-04-133558.jpg

    I recommend reading that full article that I have linked for a more complete answer in how to compare the two models.