--==================================================
--查看正在执行的SQL
SELECT s.[session_id] ,
r.[start_time] ,
r.estimated_completion_time,
r.percent_complete,
DATEDIFF(MILLISECOND, r.start_time, GETDATE()) AS elapsed_MS ,
r.[status] AS RequestStatus ,
DB_NAME(r.database_id) AS DatabaseName ,
r.[wait_type] ,
r.[wait_resource] ,
r.[wait_time] ,
r.[reads] ,
r.[writes] ,
r.[logical_reads] ,
s.[status] AS SessionStatus ,
s.[host_name] ,
s.[original_login_name] ,
s.[nt_user_name] ,
s.[program_name] ,
s.[client_interface_name] ,
c.[client_net_address] ,
SUBSTRING(qt.text, r.statement_start_offset / 2,
( CASE WHEN r.statement_end_offset = -1
THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
ELSE r.statement_end_offset
END - r.statement_start_offset ) / 2) AS ExecutingSQL ,
qp.query_plan
FROM sys.dm_exec_requests r
INNER JOIN sys.dm_exec_sessions s
ON r.session_id = s.session_id
LEFT JOIN sys.dm_exec_connections c
ON c.session_id = s.session_id
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) AS qt
CROSS APPLY sys.dm_exec_query_plan(r.plan_handle) AS qp
ORDER BY elapsed_MS DESC
查看正在执行的SQL
最新推荐文章于 2024-08-08 13:48:37 发布