会话对应的线程id
--会话,连接,阻塞,线程 select * from sys.sysprocesses where spid = @@SPID --类似于sys.sysprocesses select * from sys.dm_exec_sessions s inner join sys.dm_exec_connections c on s.session_id = c.session_id left join sys.dm_exec_requests r on r.session_id = c.session_id where s.session_id > 50 --当前会话的线程数 select s.session_id, r.connection_id, r.request_id, ot.os_thread_id from sys.dm_exec_sessions s inner join sys.dm_exec_connections c on c.session_id = s.session_id left join sys.dm_exec_requests r on s.session_id = r.session_id left join sys.dm_os_workers t on r.task_address = t.task_address left join sys.dm_os_threads ot on ot.thread_address= t.thread_address where s.session_id = @@SPID