Azure Compute Utilization doesn't match database CPU consumption

Cliff Cawley 96 Reputation points
2020-09-03T08:52:36.22+00:00

When I view my compute utilization graph and compare it to the database performance graph (even after using 'drill into logs/performance') I can't figure out why the DTU percentage is so high.

I'm experiencing intermittent connection lag with timeouts on the DTU 10 plan but I can't figure out why and the graphs seem to imply I'm underutilising anyway.

Any ideas?

22451-azuredb.png

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Ubezzi 2,776 Reputation points
    2020-09-04T03:32:47.517+00:00

    Hi @Cliff Cawley - Please take a look at the following troubleshooting guide as it will walk you through multiple scenarios, including node level and database level troubleshooting...which is the difference that you are seeing. Please see: Troubleshoot Azure SQL Database and Azure SQL Managed Instance performance issues with Intelligent Insights

    In your case, the reaching resource limits section will help you investigate:

    Consumption of available resources (DTUs), database worker threads, or database login sessions available on the monitored subscription has reached its resource limits. This is affecting performance.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.