Azure SQL Database: Queries Slow Despite Normal DTU/CPU?

AndersonAnderson
in Technical Discussion

Hi all,

Some of the queries on my Azure SQL Database are taking a lot longer than usual, even though the DTU, CPU, and memory metrics all look normal.

There haven't been any recent changes to the schema or major growth in the size of the data.

It could be because of:

  • Old statistics or poorly thought-out plans

  • Problems with parameter sniffing

  • TempDB contention or maintenance that needs to be done

  • Changes to auto-tuning

Has anyone else had this problem?

When resource metrics look normal, what is the best way to figure out why queries are taking longer than usual?

Comments

  • james.carsonjames.carson Moderator, WatchGuard Representative

    Hi @Anderson

    You may have more luck posting this to a forum specifically handling Azure and SQL issues. Most of the traffic here will be related to troubleshooting issues that occur when traversing one of WatchGuard's firewalls or other products.

    -James Carson
    WatchGuard Customer Support

  • AndersonAnderson

    @james.carson said:
    Hi @Anderson

    You may have more luck posting this to a forum specifically handling Azure and SQL issues. Most of the traffic here will be related to troubleshooting issues that occur when traversing one of WatchGuard's firewalls or other products.

    Hey!!! Thanks for the idea!
    We know that this forum is mostly about WatchGuard products.
    We posted here on purpose to reach a wider audience that may have dealt with performance issues in Azure SQL, even if it's not the usual topic of this forum.

Sign In to comment.