Question

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.

Accepted Answer

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_connections y ON x.session_id = y.session_id;

Answer

A) 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;

Answer

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;

Answer

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_background_job_queue_stats y ON x.session_id = y.session_id;

Answer

E) 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;

Mais questões de Transações e propriedades ACID