Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT es.session_id AS session_id
- ,COALESCE(es.original_login_name, '') AS login_name
- ,COALESCE(es.host_name,'') AS hostname
- ,COALESCE(es.last_request_end_time,es.last_request_start_time) AS last_batch
- ,es.status
- ,COALESCE(er.blocking_session_id,0) AS blocked_by
- ,COALESCE(er.wait_type,'MISCELLANEOUS') AS waittype
- ,COALESCE(er.wait_time,0) AS waittime
- ,COALESCE(er.last_wait_type,'MISCELLANEOUS') AS lastwaittype
- ,COALESCE(er.wait_resource,'') AS waitresource
- ,coalesce(db_name(er.database_id),'No Info') as dbid
- ,COALESCE(er.command,'AWAITING COMMAND') AS cmd
- ,sql_text=st.text
- ,transaction_isolation =
- CASE es.transaction_isolation_level
- WHEN 0 THEN 'Unspecified'
- WHEN 1 THEN 'Read Uncommitted'
- WHEN 2 THEN 'Read Committed'
- WHEN 3 THEN 'Repeatable'
- WHEN 4 THEN 'Serializable'
- WHEN 5 THEN 'Snapshot'
- END
- ,COALESCE(es.cpu_time,0)
- + COALESCE(er.cpu_time,0) AS cpu
- ,COALESCE(es.reads,0)
- + COALESCE(es.writes,0)
- + COALESCE(er.reads,0)
- + COALESCE(er.writes,0) AS physical_io
- ,COALESCE(er.open_transaction_count,-1) AS open_tran
- ,COALESCE(es.program_name,'') AS program_name
- ,es.login_time
- FROM sys.dm_exec_sessions es
- LEFT OUTER JOIN sys.dm_exec_connections ec ON es.session_id = ec.session_id
- LEFT OUTER JOIN sys.dm_exec_requests er ON es.session_id = er.session_id
- LEFT OUTER JOIN sys.server_principals sp ON es.security_id = sp.sid
- LEFT OUTER JOIN sys.dm_os_tasks ota ON es.session_id = ota.session_id
- LEFT OUTER JOIN sys.dm_os_threads oth ON ota.worker_address = oth.worker_address
- CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) AS st
- where es.is_user_process = 1
- and es.session_id <> @@spid
- and es.status = 'running'
- ORDER BY es.session_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement