sqlserver数据库查看连接数

SELECT COUNT(*) Qty FROM (
SELECT host_name
FROM sys.dm_exec_sessions
WHERE ISNULL(host_name,'')<>''
GROUP BY host_name) t