sql 用來查看當前會話的狀態

select s.session_id,s.status,s.login_time,s.host_name,
s.program_name,s.host_process_id,s.client_version,
s.client_interface_name,s.login_name,s.last_request_start_time,
s.last_request_end_time,c.connect_time,c.net_transport,
c.net_packet_size,c.client_net_address,r.request_id,r.start_time,
r.status,r.command,r.database_id,r.user_id,r.blocking_session_id,
r.wait_type,r.wait_time,r.transaction_id,r.percent_complete,
r.cpu_time,r.reads,r.writes,r.granted_query_memory
from sys.dm_exec_requests r
right outer join sys.dm_exec_sessions s
on r.session_id=s.session_id
right outer join sys.dm_exec_connections c
on s.session_id=c.session_id
where s.is_user_process=1