查看正在执行的SQL

--==================================================
--查看正在执行的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