获取数据库当前所有活动连接的脚本

最新推荐文章于 2022-09-13 14:03:31 发布

greystar

最新推荐文章于 2022-09-13 14:03:31 发布

阅读量968

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/greystar/article/details/44590275

版权

SQL 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

SQL2012 测试通过

获取连接

SELECT 
        [dbid],
        DB_NAME([dbid]) as DatabaseName, 
        COUNT([dbid]) as ConnectionsCount,
        [loginame] as LoginName,
        [status]
FROM
        [master].[sys].[sysprocesses]
WHERE
        [dbid] > 0
GROUP BY 
        [dbid], [loginame], [status];

获取事务

SELECT 
        [transaction_id] AS TranId,
        [name] AS TranName,
        [transaction_begin_time] AS TranStartTime,
        [transaction_state] AS TranState,
        [transaction_status] AS TranStatus
FROM 
        [master].[sys].[dm_tran_active_transactions];

正好用到上述功能，记录下。