Question: What are different ways to identify open transactions in SQL Server?
Answer: There are many ways to identify the open transactions. If there are some transactions which were started and not yet committed or rollback, you can use any of these to find them
Use DBCC command
There is a specific DBCC command for this.
DBCC OPENTRAN
Use SYS.SYSPROCESSES view
SELECT * FROM SYS.SYSPROCESSES WHERE OPEN_TRAN = 1
This will list out more details about the open transactions
Use SYS.DM_TRAN_SESSION_TRANSACTIONS view
SELECT * FROM SYS.DM_TRAN_SESSION_TRANSACTIONS
Reference: Pinal Dave (https://blog.sqlauthority.com)
