sql server 查看当前数据库服务的链接数

SELECT COUNT(*) AS 当前连接数
FROM sys.dm_exec_sessions
WHERE is_user_process = 1;

 

SELECT *
FROM sys.dm_exec_sessions
WHERE is_user_process = 1;