Q75464 – Tecnologia da Informação – Fundação Getulio Vargas 2018

select x.session_id, host_name, program_name, nt_domain, login_name, connect_time, last_request_end_time from sys.dm_exec_sessions x join sys.dm_clr_tasks y ON x.session_id = y.session_id;

select x.session_id, host_name, program_name, nt_domain, login_name, connect_time, last_request_end_time from sys.dm_exec_background_job_queue_stats x join sys.dm_io_pending_io_requests y ON x.session_id = y.session_id;

select x.session_id, host_name, program_name, nt_domain, login_name, connect_time, last_request_end_time from sys.dm_exec_sessions x join sys.dm_exec_background_job_queue_stats y ON x.session_id = y.session_id;

select x.session_id, host_name, program_name, nt_domain, login_name, connect_time, last_request_end_time from sys.dm_exec_sessions x join sys.dm_exec_connections y ON x.session_id = y.session_id;

select x.session_id, host_name, program_name, nt_domain, login_name, connect_time, last_request_end_time from sys.dm_audit_actions AS x join sys.dm_io_pending_io_requests ON x.session_id = y.session_id;