查询连接到数据库实例的连接数

--    查询本机连接到该数据库实例的连接数
SELECT a.spid
FROM master..sysprocesses AS a
     INNER JOIN master..SYSDATABASES AS b ON a.dbid = b.dbid
     INNER JOIN sys.dm_exec_connections AS c ON a.spid = c.session_id
WHERE b.name ='DbName' AND c.client_net_address = (SELECT TOP 1 client_net_address FROM sys.dm_exec_connections WHERE Session_id = @@SPID)
--    排除部分进程
    AND NOT a.program_name LIKE 'Microsoft%'

--查询连接到该实例的所有客户端
SELECT DISTINCT client_net_address FROM sys.dm_exec_connections WHERE local_net_address='192.168.0.1'