---

USE [replTransVas];
GO
SET NOCOUNT ON;

SELECT
    r.session_id,
    r.status,
    r.total_elapsed_time AS elapsedMs,
    r.cpu_time AS cpuMs,
    r.logical_reads,
    r.blocking_session_id,
    r.wait_type,
    SUBSTRING(
        t.text,
        r.statement_start_offset / 2 + 1,
        (
            CASE
                WHEN r.statement_end_offset = -1
                    THEN DATALENGTH(t.text)
                ELSE r.statement_end_offset
            END - r.statement_start_offset
        ) / 2 + 1
    ) AS runningStatement,
    t.text AS fullBatch,
    p.query_plan
FROM sys.dm_exec_requests r
OUTER APPLY sys.dm_exec_sql_text(r.sql_handle) t
OUTER APPLY sys.dm_exec_query_plan(r.plan_handle) p
WHERE r.session_id <> @@SPID
    AND r.database_id = DB_ID()
    AND r.command = N'SELECT'
ORDER BY r.total_elapsed_time DESC;