In this post, I am sharing a script to find the all open transactions in SQL Server. If your server has unwanted open transactions, it degrades the performance of other dependent transactions. There are many ways to find open transactions in SQL Server. Here, I used sys.dm_tran_database_transactions view to find out open transactions. Below is … Continue reading Open transactions in SQL Server