show execution date and time for top queries / top procedures

MikeWeaver

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?

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. 

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?  

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.