Options

Query duration

garybr44garybr44 Posts: 4 Bronze 1
edited October 22, 2014 9:13AM in SQL Monitor Previous Versions
I'm a new user so I'm just trying to understand information shown in an event/alert.

I receive an alert that I have a long running query. The query duration shows xxx.xxxx seconds.

Is that showing how long the query took to run?

Comments

  • Options
    Thank you for your post.

    The Query Duration is the time from the Query start time that the query finished. This is not necessarily the execution time though
  • Options
    garybr44garybr44 Posts: 4 Bronze 1
    Thanks. So if it shows a duration time of 765.222, does that mean in took about 12 minutes for the query to finish?

    Is there anywhere that I can see the execution time?
Sign In or Register to comment.