Azure High SQL Server DTU - how to analyse?

T West 136 Reputation points
2020-12-10T22:01:15.807+00:00

Hi,

Each morning around 8am our Azure SQL Server DTU spikes to 100%. We thought it may have been the plan we were on (100 DTU's) so we increased the plan to 200 DTU's (S4), but unfortunately each morning we are still hitting the 100% DTU mark. I've tried looking in the Azure portal to see if the queries are displayed which could be affecting the performance but can only see CPU % that the queries are utilizing. Is there a better area I can run some analysis please?

Thank you

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2020-12-10T22:19:36.853+00:00

    @T West

    This is issue is duplicate of https://learn.microsoft.com/en-us/answers/questions/194119/index.html

    We will shortly redirect this thread to thread above.

    Thanks
    Navtej S

    0 comments