查看数据库连接数:
select @@connections
查看当前连接数:
SELECT * FROM [Master].[dbo].[SYSPROCESSES] WHERE [DBID] IN (SELECT [DBID]FROM [Master].[dbo].[SYSDATABASES] )
可以添加where条件筛选
查看数据库最大连接数:
select @@max_connections
获得当前设置的最大连接数:
select value from master.dbo.sysconfigures where [config]=103
----用户连接数
SELECT login_name,
Count(0) user_count
FROM Sys.dm_exec_requests dr WITH(nolock)
RIGHT OUTER JOIN Sys.dm_exec_sessions ds WITH(nolock)
ON dr.session_id = ds.session_id
RIGHT OUTER JOIN Sys.dm_exec_connections dc WITH(nolock)
ON ds.session_id = dc.session_id
WHERE ds.session_id > 50
GROUP BY login_name
ORDER BY user_count DESC
使用net_address唯一查看当前用户数(这个比较准)
select connectnum=count(distinct net_address)-1 from master..sysprocesses