Azure SQL monitoring high DTU

Question

We're getting spikes from time to time but can't find what causes it.

score 8 · Accepted Answer · answered Jul 23 '15 at 20:21

8

The following will show you a log of the 100 most recent DTU logs. As of now, a log entry is created every 15 seconds.

SELECT TOP 100 *
FROM sys.dm_db_resource_stats
ORDER BY end_time DESC

answered Jul 23 '15 at 20:21

ItsMe

1

What database or version of SQL server is this? I cannot find the table. – Triynko Jun 09 '16 at 20:55
@Triynko: This works for my databases, which are running on Sql Azure v12. The database is specified in the query: [sys] – ItsMe Jun 10 '16 at 14:55
is there a nice way to get 'nulls' from this query if it doesn't exist – Simon_Weaver Mar 29 '17 at 21:00

score 1 · Answer 2 · edited May 23 '17 at 10:29

1

Please have a check on the below links which talks about Azure SQL Database Throughput Unit (DTU).

Regards, Mekh.

edited May 23 '17 at 10:29

Community

answered Nov 06 '14 at 05:07

Mekh Subba

1

You should post the main material in your answer and use the links for reference only. – Nov 06 '14 at 05:16
Will do the same from now on. Thanks – Mekh Subba Nov 06 '14 at 06:46

2 Answers2