查长时间运行事务

最新推荐文章于 2021-02-01 21:30:35 发布

吉普赛的歌

最新推荐文章于 2021-02-01 21:30:35 发布

阅读量622

点赞数

分类专栏： # 常用代码

本文链接：https://blog.csdn.net/yenange/article/details/78366784

版权

常用代码专栏收录该内容

93 篇文章 3 订阅

订阅专栏

SELECT  b.[session_id]
       ,b.[open_transaction_count]
       ,b.[total_elapsed_time]
       ,a.[name] AS 'transaction_name'
       ,b.[command]
       ,a.[transaction_begin_time]
       ,b.[blocking_session_id]
       ,DB_NAME(b.[database_id]) AS 'current_dbname'
       ,dest.[text]
FROM    sys.[dm_tran_active_transactions] AS a
        INNER JOIN sys.[dm_exec_requests] AS b ON a.[transaction_id] = b.[transaction_id]
        OUTER APPLY sys.dm_exec_sql_text(b.sql_handle) AS dest
WHERE   [b].[session_id] != @@SPID;