sql server – How can I identity query that use most DTU?

I’m not sure which are the most resource consumer on a DB I have on Azure (which is a Premium P2: 250 DTUs):

enter image description here

The most, using this query:

SELECT  
    AVG(avg_cpu_percent) AS 'Average CPU Utilization In Percent', 
    MAX(avg_cpu_percent) AS 'Maximum CPU Utilization In Percent', 
    AVG(avg_data_io_percent) AS 'Average Data IO In Percent', 
    MAX(avg_data_io_percent) AS 'Maximum Data IO In Percent', 
    AVG(avg_log_write_percent) AS 'Average Log Write Utilization In Percent', 
    MAX(avg_log_write_percent) AS 'Maximum Log Write Utilization In Percent', 
    AVG(avg_memory_usage_percent) AS 'Average Memory Usage In Percent', 
    MAX(avg_memory_usage_percent) AS 'Maximum Memory Usage In Percent' 
FROM sys.dm_db_resource_stats; 

enter image description here

But if I watch at the query Performance overwiew, I don’t see these problems:

enter image description here

So, what can I do to understand where the real problem is? These DTU for this machine is so higher.

Read more here: Source link