Azure SQL monitoring high DTU

Question

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

• How to monitor the Azure SQL DTU usage?
• How can I find what are the high DTU queries in live?

Answer 1

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

Answer 2

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

http://azure.microsoft.com/blog/2014/09/11/azure-sql-database-introduces-new-near-real-time-performance-metrics/

Azure SQL Database "DTU percentage" metric

http://msdn.microsoft.com/en-us/library/azure/dn741336.aspx

Regards, Mekh.