Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- getdate() CurrentTime,
- s.session_id,
- r.status,
- r.blocking_session_id 'Blk by',
- r.wait_type,
- wait_resource,
- r.wait_time / (1000.0) 'Wait Sec',
- r.cpu_time,
- r.logical_reads,
- r.reads,
- r.writes,
- r.total_elapsed_time / (1000.0) 'Elaps Sec',
- Substring(st.TEXT,(r.statement_start_offset / 2) + 1,
- ((CASE r.statement_end_offset
- WHEN -1
- THEN Datalength(st.TEXT)
- ELSE r.statement_end_offset
- END - r.statement_start_offset) / 2) + 1) AS statement_text,
- Coalesce(Quotename(Db_name(st.dbid)) + N'.' + Quotename(Object_schema_name(st.objectid,st.dbid)) + N'.' + Quotename(Object_name(st.objectid,st.dbid)),
- '') AS command_text,
- r.command,
- s.login_name,
- s.host_name,
- s.program_name,
- s.last_request_end_time,
- s.login_time,
- r.open_transaction_count
- INTO support.ProcessActualState
- FROM sys.dm_exec_sessions AS s
- JOIN sys.dm_exec_requests AS r
- ON r.session_id = s.session_id
- CROSS APPLY sys.Dm_exec_sql_text(r.sql_handle) AS st
- WHERE r.session_id != 0
- ORDER BY r.cpu_time desc, r.status,
- r.blocking_session_id,
- s.session_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement