SQL 서버의 프로세스ID와 OS의 프로세스ID 맵핑

select hostname, hostprocess
from master..sysprocesses
where  spid = 68

select s.host_name, s.host_process_id, t.os_thread_id, s.session_id
from sys.dm_exec_sessions s
join sys.dm_exec_requests er on s.session_id = er.session_id
join sys.dm_os_workers w on er.task_address = w.task_address
join sys.dm_os_threads t on w.thread_address = t.thread_address
where s.session_id = 68;

댓글

댓글 쓰기

이 블로그의 인기 게시물

Oracle NLS_DATE_FORMAT 변경

Stop console process using Ctrl+C.

Alternative to IValueConvert, QuickConverter