Calculating DTU's for Azure SQL Database

  • Comments posted to this topic are about the item Calculating DTU's for Azure SQL Database

    Regards,Ganapathi varma, MCSAEmail: gana20m@gmail.com

  • gana20m - Tuesday, February 13, 2018 9:20 PM

    Comments posted to this topic are about the item Calculating DTU's for Azure SQL Database

    Good morning, I have an existing Azure Database on the S0 Tiered plan, however I believe that this database is not correctly spec'ed.  Is there any way I can get the measurements you talk about in this blog from Azure itself.  Regards,

    Martin

  • I liked the article until I read the content of the DTU calculation webpage
    At least the first 2 paragraphs are yours.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • I am sure you have the up time SLA wrong, should it 99.99% ?

  • DrMDodd - Wednesday, February 14, 2018 2:42 PM

    gana20m - Tuesday, February 13, 2018 9:20 PM

    Comments posted to this topic are about the item Calculating DTU's for Azure SQL Database

    Good morning, I have an existing Azure Database on the S0 Tiered plan, however I believe that this database is not correctly spec'ed.  Is there any way I can get the measurements you talk about in this blog from Azure itself.  Regards,

    Martin

    Dr Dodd - those  perfmon counters are from a local SQL Server. S0 is quite low powered ( IMO ) you probably will need to scale up. If this database has come from a local SQL Server then run the tool against that with a representative workload.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply