How can we help you today? How can we help you today?

show execution date and time for top queries / top procedures

Is there any way of seeing the execution date / time for the top queries or top procedures. I can see an execution count but nothing else?
Mike Weaver
0

Comments

3 comments

Sort by
  • Ben_P
    Hi Mike,

    From the top of the overview page you can select the time frame you want to view, you can also slide this window along the timeline and shrink or increase the window. 

    Then, the top queries and top procedures shown will update to the ones that ran during the window you highlighted at the top.
    Ben_P
    0
  • MikeWeaver
    Hi Ben - I understand the window date/time but when I'm trying to see is the exact date/time for the individual executions. We'd also like to see the Login name for the specific execution. Are either available?
    MikeWeaver
    0
  • Ben_P
    Hi Mike,

    I'm afraid it isn't possible to see the exact date/time for the individual query execution or the login that it came from.

    Under the Current activity tab in Overviews, you can see the login for any queries currently running. 



    Ben_P
    0

Add comment

Please sign in to leave a comment.