Home Forums Article Discussions Article Discussions by Author Discuss content posted by Ganapathi varma Calculating DTU's for Azure SQL Database RE: Calculating DTU's for Azure SQL Database

  • February 19, 2018 at 8:05 am

    #1980275

    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.