Skip to content

SQL Server查询当前连接数

Jump to bottom
L edited this page Dec 18, 2017 · 1 revision

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

SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT 
    [DBID]
FROM 
    [Master].[dbo].[SYSDATABASES]
WHERE 
    NAME='Your Db Name'
)
Clone this wiki locally