行数就是连接数,每一行是连接详情
SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
WHERE
NAME='Your Db Name'
)
行数就是连接数,每一行是连接详情
SELECT * FROM
[Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN ( SELECT
[DBID]
FROM
[Master].[dbo].[SYSDATABASES]
WHERE
NAME='Your Db Name'
)
本文标题:SQL Server查询当前连接数
本文链接:https://www.haomeiwen.com/subject/rmbpwxtx.html
网友评论