Best way to find who is running what query

Greg

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

Evan Moss

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