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.)
Most requests (~90%)
It appears to be random different queries each time