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;
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;
Thiet ke nha dep
답글삭제biet thu dep
thiet ke nha
nha pho dep