[code sql]
select
-- object_name(sql_text.objectid) as 'SP명'
ses.session_id
, ses.host_name
, ses.program_name
, ses.client_interface_name
, ses.login_name
--, (case when sr.statement_end_offset = -1
-- then len(convert(nvarchar(max), sql_text.text)) * 2
-- else sr.statement_end_offset end - sr.statement_start_offset)/2)
, *
from sys.dm_os_schedulers as ss with (nolock)
inner join sys.dm_os_tasks as st with (nolock) on ss.scheduler_id = st.scheduler_id
inner join sys.dm_exec_requests as sr with (nolock) on st.request_id = sr.request_id
inner join sys.dm_exec_sessions as ses with (nolock) on sr.session_id = ses.session_id
cross apply sys.dm_exec_sql_text(sr.sql_handle) as sql_text
where ss.scheduler_id = 24 -- cpu 번호
[/code]
