DBA : Get open transactions in SQL Server

— Open Transactions in the current database
DBCC OPENTRAN

SELECT session_id, open_transaction_count
FROM sys.dm_exec_requests

Advertisements