Sudden DTU spikes in Azure SQL

2
votes

Our SQL Azure databases gets sudden spikes on random moments during the week. Once these spikes happen they don't stop anymore. There is nothing happening abnormally at those moments.

If we scale up or scale down our SQL the spikes stop and we have our normal behavior again.

How can we troubleshoot this problem? I have a feeling something is 'stuck' and is suddenly hogging our SQL.

enter image description here

1
sqlsql-serverazureazure-sql-database

1 Answers

5
votes

Use Query Store to identify the culprits. Activate Query Performance Insight on your account and then review the top consuming queries when the DTU spikes occur.

If we scale up or scale down our SQL the spikes stop and we have our normal behavior again

That looks like something only an Azure ticket can investigate.