Issues with random slow requests to Azure SQL Database from AKS

Peter Gerrard 6 Reputation points
2022-03-22T10:06:38.327+00:00

We currently have a collection of apps running in AKS (UK South Region) that connect to Azure SQL DBs (Also UK South Region). Most of the time connections and queries take ~10ms but every so often (1/50-100) a single request increases to 1s according to Application Insights. When looking at the database we see that the query is still taking a ~10 of milliseconds.

The databases are relatively small (couple thousand rows) and we've tried Basic/Standard (10 DTUs and 200 DTUs) and seen no change in behaviour.

The apps are running also don't appear to be hitting any resource limits looking at AKS Monitoring.

This is happening across multiple apps/databases/servers

Any ideas on what could be causing the issues, we've not found anything in the database (no deadlocks/high wait times etc.)

185593-image.png
185468-image.png

Most requests (~90%)

185605-image.png

Other times:
It appears to be random different queries each time
185631-image.png
185594-image.png

Azure SQL Database
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,821 questions
{count} vote