• Hi,

    as per below query there no wait type and blocking

    /* running requests */
    SELECT s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name, s.status AS session_status,
      db_name(er.database_id) AS database_name, er.status AS request_status, er.command,
      er.wait_type, er.wait_time / 1000.0 AS wait_sec, er.last_wait_type, er.wait_resource,
      er.blocking_session_id, bs.host_name AS blocking_host, bs.program_name AS blocking_program, bs.login_name AS blocking_login,
      er.transaction_id, er.open_transaction_count,
      er.cpu_time / 1000.0 AS cpu_sec, er.total_elapsed_time / 1000.0 AS total_elapsed_sec, er.start_time, er.reads, er.writes, er.logical_reads,
      CASE er.transaction_isolation_level WHEN 1 THEN 'ReadUncomitted' WHEN 2 THEN 'ReadCommitted' WHEN 3 THEN 'Repeatable' WHEN 4 THEN 'Serializable' WHEN 5 THEN 'Snapshot' ELSE 'Unspecified' END AS isol_level,
      OBJECT_NAME(st.objectid, st.dbid) AS object_name, er.sql_handle, er.plan_handle, st.[text]
    FROM sys.dm_exec_requests er
      INNER JOIN sys.dm_exec_sessions s ON er.session_id = s.session_id
      LEFT OUTER JOIN sys.dm_exec_query_memory_grants mg ON er.session_id = mg.session_id AND er.request_id = mg.request_id
      LEFT OUTER JOIN sys.dm_exec_sessions bs ON er.blocking_session_id = bs.session_id
      OUTER APPLY sys.dm_exec_sql_text(er.sql_handle) st
    WHERE s.is_user_process = 1
      AND s.session_id <> @@SPID
      AND er.last_wait_type <> 'SP_SERVER_DIAGNOSTICS_SLEEP'

    output

    request_status - running
    wait type - NULL
    blocking_session_id - 0
    blocking_host     - NULL
    blocking_program - NULL

    open_transaction_count - 1
    cpu_sec - 306.109000
    total_elapsed_sec - 306.109000    
    reads - 0    
    writes    - 0

    logical_reads - 1567        
    isol_level - Serializable

    any further check , pls advise

    Regards
    Binu