O administrador de uma instalação MS SQL Server detectou a
existência de uma transação em atividade no sistema, cujo
processamento está muito demorado.
Assinale a opção que apresenta a consulta que fornece os dados
adequados para que a transação seja corretamente identificada e
o comando kill executado com segurança.
A
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;
B
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;
C
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;
D
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
E
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;