Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT SPID = er.session_id
- ,STATUS = ses.STATUS
- ,[Login] = ses.login_name
- ,Host = ses.host_name
- ,BlkBy = er.blocking_session_id
- ,DBName = DB_Name(er.database_id)
- ,CommandType = er.command
- ,ObjectName = OBJECT_NAME(st.objectid)
- ,CPUTime = er.cpu_time
- ,StartTime = er.start_time
- ,TimeElapsed = CAST(GETDATE() - er.start_time AS TIME)
- ,SQLStatement = st.text
- FROM sys.dm_exec_requests er
- OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st
- LEFT JOIN sys.dm_exec_sessions ses
- ON ses.session_id = er.session_id
- LEFT JOIN sys.dm_exec_connections con
- ON con.session_id = ses.session_id
- WHERE st.text IS NOT NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement