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:
select percent_complete,
dateadd (second ,( datediff( second ,start_time , getdate())* 100 )/percent_complete , start_time)
as EstimatedEndTime, command
from sys . dm_exec_requests
where session_id = ID_OF_SESSION
This will show you the percentage of completion, an estimate for the completion and the command being executed.