Explanation of duration in MS

  • stevec883

    Old Hand

    Points: 374

    I have a query that is long running. It takes about 30 seconds to run. My question is why does this graph in the query store show that it runs for 4 million MS, which would be 66 minutes?

  • sterling3721

    SSC-Addicted

    Points: 470

    the graph says it clearly, "total duration", 30 seconds per execution x 1000 times = 30,000 seconds.

    you need to switch to Avg, the y-axis would display "avg duration", which should be close to your 30 seconds.

  • stevec883

    Old Hand

    Points: 374

    Thanks Sterling

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply