查询未提交的事务、打开的游标等

未提交的事务

-- 查询未提交的事务
 

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT es.session_id, es.login_name, es.host_name, est.text
, cn.last_read, cn.last_write, es.program_name
FROM sys.dm_exec_sessions es
INNER JOIN sys.dm_tran_session_transactions st  
ON es.session_id = st.session_id
INNER JOIN sys.dm_exec_connections cn
ON es.session_id = cn.session_id
CROSS APPLY sys.dm_exec_sql_text(cn.most_recent_sql_handle) est
LEFT OUTER JOIN sys.dm_exec_requests er
ON st.session_id = er.session_id
AND er.session_id IS NULL


--关闭
--kill  session_id

打开的游标：

SELECT 
session_id , 
cursor_id , 
name , 
creation_time , 
is_open FROM 
sys.dm_exec_cursors(0)WHERE 
is_open = 1;