\nUse this query in conjunction with sp_who to display running tasks and determine whether there are sessions blocking other sessions, and who is executing the query (sp_who)
\n<\/p>\n
\r\nSELECT command,\r\n r.session_id, r.blocking_session_id,\r\n s.text,\r\n start_time,\r\n percent_complete, \r\n CAST(((DATEDIFF(s,start_time,GetDate()))\/3600) as varchar) + ' hour(s), '\r\n + CAST((DATEDIFF(s,start_time,GetDate())%3600)\/60 as varchar) + 'min, '\r\n + CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ' sec' as running_time,\r\n CAST((estimated_completion_time\/3600000) as varchar) + ' hour(s), '\r\n + CAST((estimated_completion_time %3600000)\/60000 as varchar) + 'min, '\r\n + CAST((estimated_completion_time %60000)\/1000 as varchar) + ' sec' as est_time_to_go,\r\n dateadd(second,estimated_completion_time\/1000, getdate()) as est_completion_time \r\nFROM sys.dm_exec_requests r\r\nCROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s\r\n--WHERE r.command like ('%DBCC%')\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Use this query in conjunction with sp_who to display running tasks and determine whether there are sessions blocking other sessions, and who is executing the query (sp_who) SELECT command, r.session_id, r.blocking_session_id, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))\/3600) as varchar) + ‘ hour(s), … Continue reading