SQL Server查询当前连接数

行数就是连接数,每一行是连接详情

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT 
    [DBID]
FROM 
    [Master].[dbo].[SYSDATABASES]
WHERE 
    NAME='Your Db Name'
)
posted @ 2017-12-18 10:43  Lulus  阅读(9876)  评论(0编辑  收藏  举报