---

  SELECT is_read_committed_snapshot_on
  FROM sys.databases
  WHERE database_id = DB_ID();


 SELECT
      r.session_id,
      r.blocking_session_id,
      r.status,
      r.command,
      r.wait_type,
      r.wait_time,
      r.wait_resource,
      DB_NAME(r.database_id) AS DatabaseName,
      s.host_name,
      s.program_name,
      s.login_name,
      transaction_begin_time,
      st.text AS SqlText
  FROM sys.dm_exec_requests r
  JOIN sys.dm_exec_sessions s
      ON s.session_id = r.session_id
  LEFT JOIN sys.dm_tran_session_transactions tst
      ON tst.session_id = r.session_id
  LEFT JOIN sys.dm_tran_active_transactions tat
      ON tat.transaction_id = tst.transaction_id
  CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) st
  WHERE r.session_id <> @@SPID
  ORDER BY
      CASE WHEN r.blocking_session_id <> 0 THEN 0 ELSE 1 END,
      r.session_id;