carehart

-- Who is running what at this instant
SELECT dest.text AS [Command text] ,
der.total_elapsed_time as 'total_elapsed_time (ms)',
DB_NAME(der.database_id) AS DatabaseName ,
der.command , des.login_time , des.[host_name] , des.[program_name] , der.session_id
FROM sys.dm_exec_requests der
INNER JOIN sys.dm_exec_connections dec
ON der.session_id = dec.session_id
INNER JOIN sys.dm_exec_sessions des
ON des.session_id = der.session_id