Best way to find who is running what query

GregGreg Posts: 2
edited December 15, 2014 3:24PM in SQL Monitor Previous Versions
Hi,

What is the best way, if possible at all, to find a user running a query that is shown in the wait stats pane? Do I need to run a continual trace to capture this?

Thanks

Comments

  • Hi Greg,

    Thanks for your post.

    Doing a trace is probably the best way of getting the user information for the query. SQL Monitor should give you the query plan if you want more details, but my understanding is that you can't find the user from that.

    You can also reduce the threshold on the long running query alert so that you get more of them. Those alerts should say the user in them.

    Regards,
    Evan
    Evan Moss
    Product Support
    (866) 627-8107
Sign In or Register to comment.