We have Azure SQL on S3 level.
For about the last 3 hours, we've been hitting 90%+ DTU, with occasional dips down to <10%. Here's the query I'm using to see the avg DTU %:
SELECT end_time,
(SELECT Max(v)
FROM (VALUES (avg_cpu_percent), (avg_data_io_percent), (avg_log_write_percent)) AS
value(v)) AS [avg_DTU_percent]
FROM sys.dm_db_resource_stats;
Here's some example data:
end_time avg_DTU_percent2015-09-11 05:03:05.740 98.58
2015-09-11 05:02:50.710 97.86
2015-09-11 05:02:35.680 97.92
2015-09-11 05:02:20.680 89.62
2015-09-11 05:02:05.633 0.21
2015-09-11 05:01:50.490 42.20
2015-09-11 05:01:35.337 37.96
2015-09-11 05:01:20.290 66.99
2015-09-11 05:01:05.273 64.36
2015-09-11 05:00:49.417 96.67
2015-09-11 05:00:34.387 97.72
I pulled a list of all current connections and did KILL for all active SPID. We have a couple of scheduled jobs that run periodically, so disabled those.
And still the DTU% keeps spiking.
This is completely out of character for our daily use but is clearly obvious to our users.
I'm now not sure if this is some problem in our application, or an issue on that particular Azure database.