none
Standard vs premium service tier RRS feed

  • Question

  • Hi,

    I am preparing for the exam and want to ask what is efficient way to compare Standard and Premium DTU-based service tiers.

    Lets say 100 DTU Premium tier is better than 400 DTU Standard tier?

    CPU - high for both,

    IO throughput for Standard - 2.5*400=1000
    IO throughput for Premium - 48*100=4800

    IO latency for Premium is better than Standard read and writes.

    Can I rely on this 
    https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tiers-dtu#choosing-a-service-tier-in-the-dtu-based-purchasing-model

    Thanks

    Friday, July 20, 2018 3:05 PM

All replies

  • Hello,

    You can fully rely on Azure SQL documentation. If you want to do some more benchmarking try below resources:



    http://www.sqlservercentral.com/articles/Azure+SQL+database/135368/


    https://cbailiss.wordpress.com/2015/01/31/azure-sql-database-v12-ga-performance-inc-cpu-benchmaring/



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, July 20, 2018 8:12 PM