Where does the DataIO in Azure Query Performance Insights come from, when single queries are fast
Asked Answered
R

1

7

The following screenshot shows a day of SQL queries and the amount of resources they consume.

enter image description here

As you can see, single queries, while there are many don't seem to consume much resources.

The bar chart shows a load of 0.08% of Data IO load. The line chart below on the other hand shows a constant utilization of about 15% to 25%. Even if the line is a running average, it does not match the bar chart. The single queries in the table below also don't seem to consume much resources.

Where does this overhead come from? Does it just hide internal queries? Do I read the visualization wrong?

Rootstock answered 4/8, 2021 at 11:37 Comment(0)
I
2

Click on query id with highest IO, copy the query text and execute in SQL server to get queries which are taking huge resources to optimize them further

Iberian answered 1/9, 2021 at 10:33 Comment(0)

© 2022 - 2024 — McMap. All rights reserved.