SELECT sqltext . TEXT , req . session_id , req . status , req . command , req . cpu_time , req . total_elapsed_time , req . user_id , req . reads , s . login_name FROM sys . dm_exec_requests req inner join sys . dm_exec_sessions s on req . session_id = s . session_id CROSS APPLY sys . dm_exec_sql_text ( sql_handle ) AS sqltext