Long running transactions
Last updated:
Warning: Review and test in a non-production environment before running.
-- Are there long running transactions affecting the version store
SELECT
transaction_id,
session_id,
transaction_sequence_num,
is_snapshot,
max_version_chain_traversed,
elapsed_time_seconds
FROM sys.dm_tran_active_snapshot_database_transactions
ORDER BY elapsed_time_seconds DESC
GO