Trying to understand duration column in Azure Sql DB Query Performance Insight
I have a query that runs for a long time, according to Query Performance Insight, and I tracked it down to a Runbook we use to export the azure db to our own copy of a backup. However, it says it is running for 8-9 hours every 24 hours. This can’t be right.
First screen shot: Query Performance Insight showing that my query ran for 8 hours and 51 minutes.
Second screenshot: The details of the query show that it ran for over 2 hours between 8-9 PM and for over 6 hours between 9 and 10 pm. This does not make sense to me.
Screenshot 3: We use a scheduled runbook to do the backup and it finishes most nights in under a minute.
Why is the backup of the db (which is running the query) finishing in under a minute and yet the query supposedly takes 8 hours during a 2 hour time frame.
Read more here: Source link
