What is running on your SQL Server?

 We can check execution status on our SQL Server by using sys.dm_exec_requests like follows. It also tell us the execution status:

e.g. 
SELECT  t.text, r.*
FROM     sys.dm_exec_requests r 
CROSS APPLY   sys.dm_exec_sql_text(r.sql_handle) t