Ver consultas sql monitor

[Libras]

Desde el management studio puedes ver cuales son los queries que se estan ejecutando usando las vistas de sistema, algo como esto:

Código SQL:

SELECT r.session_id, r.[STATUS], r.wait_type,
    ss.login_name, ss.host_name,ss.program_name,
     --r.scheduler_id, 
    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 [statement_executing],
        DB_NAME(qt.[dbid]) AS [DatabaseName],
        OBJECT_NAME(qt.objectid) AS [ObjectName],r.blocking_session_id,
        r.cpu_time, r.total_elapsed_time, r.reads, r.writes, 
        r.logical_reads, r.plan_handle 
    FROM sys.dm_exec_requests AS r
    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS qt
    LEFT JOIN sys.dm_exec_sessions AS ss ON (ss.session_id=r.session_id)
    WHERE r.session_id > 50