We’ve seen how to find out what users are doing in our SQL Server boxes, but, how about knowing where a query i in it’s execution?
Well, I found a query that help’s with that.
First you need to know the session id you want to monitor. Then open a query windows and type:
This will show you the percentage of completion, an estimate for the completion and the command being executed.