What SQL Statements Are Currently Running

-- What SQL Statements Are Currently Running?SELECT  start_time,'Duration(secs)' = datediff(ss,start_time, getdate()) , [Spid] = session_Id, ecid, [Database] = DB_NAME(sp.dbid), [User] = nt_username, [Status] = er.status, [Wait] = wait_type, [Individual Query] = SUBSTRING (qt.text,          er.statement_start_offset/2,(CASE WHEN er.statement_end_offset = -1       THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2                ELSE er.statement_end_offset END -                             er.statement_start_offset)/2),[Parent Query] = qt.text, Program = program_name, Hostname, nt_domainFROM sys.dm_exec_requests erINNER JOIN sys.sysprocesses sp ON er.session_id = sp.spidCROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qtWHERE session_Id > 50              -- Ignore system spids.AND session_Id NOT IN (@@SPID)     -- Ignore this current statement.and spid = 55ORDER BY 1 DESC, 2

Run the above query against the target server, you can know What SQL Statements Are Currently Running.