Understanding and Using sys.dm_exec_sessions in SQL Server
https://www.mssqltips.com/sqlservertip/5507/understanding-and-using-sysdmexecsessions-in-sql-server/
Check for open transactions:
SELECT session_id, open_transaction_count FROM sys.dm_exec_sessions WHERE open_transaction_count > 0;
Comments
Post a Comment