32 lines
1.4 KiB
HTML
32 lines
1.4 KiB
HTML
|
|
<div id="sina_keyword_ad_area2" class="articalContent ">
|
|
<div>SELECT</DIV>
|
|
<div>SPID = er.session_id <wbr></DIV>
|
|
<div>,STATUS = ses.STATUS <wbr></DIV>
|
|
<div>,[Login] = ses.login_name <wbr></DIV>
|
|
<div>,Host = ses.host_name <wbr></DIV>
|
|
<div>,BlkBy = er.blocking_session_id <wbr></DIV>
|
|
<div>,DBName = DB_Name(er.database_id) <wbr></DIV>
|
|
<div>,CommandType = er.command <wbr></DIV>
|
|
<div>,SQLStatement = st.text <wbr></DIV>
|
|
<div>,ObjectName = OBJECT_NAME(st.objectid) <wbr></DIV>
|
|
<div>,ElapsedMS = er.total_elapsed_time <wbr></DIV>
|
|
<div>,CPUTime = er.cpu_time <wbr></DIV>
|
|
<div>,IOReads = er.logical_reads + er.reads <wbr></DIV>
|
|
<div>,IOWrites = er.writes <wbr></DIV>
|
|
<div>,LastWaitType = er.last_wait_type <wbr></DIV>
|
|
<div>,StartTime = er.start_time <wbr></DIV>
|
|
<div>,Protocol = con.net_transport <wbr></DIV>
|
|
<div>,ConnectionWrites = con.num_writes <wbr></DIV>
|
|
<div>,ConnectionReads = con.num_reads <wbr></DIV>
|
|
<div>,ClientAddress =
|
|
con.client_net_address <wbr></DIV>
|
|
<div>,Authentication = con.auth_scheme <wbr></DIV>
|
|
<div>FROM sys.dm_exec_requests er <wbr></DIV>
|
|
<div>OUTER APPLY sys.dm_exec_sql_text(er.sql_handle)
|
|
st <wbr></DIV>
|
|
<div>LEFT JOIN sys.dm_exec_sessions ses ON ses.session_id =
|
|
er.session_id <wbr></DIV>
|
|
<div>LEFT JOIN sys.dm_exec_connections con ON con.session_id =
|
|
ses.session_id <wbr></DIV>
|
|
</div>
|