Azure SQL Database: Dead simple queries taking long time to execute

Modestas 1 Reputation point
2021-03-31T06:16:10.397+00:00

Hey there.

After using SQL Database for quiet a while I notices that it's randomly misbehaving.
Current plan I got is Premium P1: 125 DTUs, which should be more than enough for my loads.

There are moments when queries like this:

select Id, Name, Surname, Age
from MyPeople
where Id = 'someId'

is taking more than a minute. The Id is primary key and index exists.
To make this harder to solve - this is random and out of ~100 queries one might take long time, while others take less than a second.
Checking Query Performance Insights I can not see that query or other long running queries at all (this make me believe that the tool can not be trusted for performance insights since it shows random data). The resource usage during the "interesting" moments are negligible, meaning that CPU, RAM and IO is bellow 10% of total capacity.
Query Performance Recommendations also show no suggestion as well.

Are there any other ways to get some insight what might be going on with database itself?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Navtej Singh Saini 4,216 Reputation points Microsoft Employee
    2021-04-06T00:29:44.063+00:00

    @Modestas

    Have you looked at using the Intelligent Insights for getting more details about your Database. Also as checking this performance issue will need access to your Azure Resources, We recommend raising issue with Azure Support. Please share the ticket number and we can get more traction regarding the same.

    Regards
    Navtej S