sys.dm_tran_active_transactions
sys.dm_tran_active_transactions (Transact-sql) - SQL Server | Microsoft Docs