SqlServer 查运行进程
时间：2021-07-01 10:21:17
帮助过：13人阅读
=
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
,SQLStatement =
st.text
,ObjectName =
OBJECT_NAME(st.objectid)
,ElapsedMS =
er.total_elapsed_time
,CPUTime =
er.cpu_time
,IOReads = er.logical_reads +
er.reads
,IOWrites =
er.writes
,LastWaitType =
er.last_wait_type
,StartTime =
er.start_time
,Protocol =
con.net_transport
,ConnectionWrites =
con.num_writes
,ConnectionReads =
con.num_reads
,ClientAddress =
con.client_net_address
,Authentication =
con.auth_scheme
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 er.session_id >
50
ORDER BY
er.blocking_session_id DESC
,er.session_id
SqlServer 查运行进程
标签：color blocking pre requests ssi lse dbn reads request
