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

Popular posts from this blog

Understanding and Using SQL Server sys.dm_exec_requests

https://www.mssqltips.com/sqlservertip/5521/understanding-and-using-sql-server-sysdmexecrequests/   Find blocking / waiting: SELECT session_id , blocking_session_id , start_time , wait_type , wait_type FROM sys . dm_exec_requests WHERE blocking_session_id > 0 ; Active query plan: . SELECT DER . session_id , DEQP . query_plan FROM sys . dm_exec_requests AS DER CROSS APPLY sys . dm_exec_query_plan ( DER . plan_handle ) AS DEQP WHERE NOT DER . status IN ( 'background' , 'sleeping' ); Get % complete SELECT session_id , start_time , status , database_id , percent_complete FROM sys . dm_exec_requests WHERE command = 'DBCC TABLE CHECK' ; , .
Read more