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):
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;
But if I watch at the query Performance overwiew, I don’t see these problems:
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



