以下示例返回连接到服务器的连接数,并显示起始 IP 地址和各连接的端口。 SELECT session_id, client_net_address, client_tcp_port FROM sys.dm_exec_connections; GO
-- locked sql
SELECT *
FROM sys.dm_exec_requests
WHERE status = N'suspended';
GO
SELECT *
FROM sys.dm_exec_requests
WHERE status = N'suspended';
GO
-- show login database stutus
SELECT login_name ,nt_user_name,COUNT(session_id) AS session_count
FROM sys.dm_exec_sessions
GROUP BY login_name,nt_user_name;
SELECT login_name ,nt_user_name,COUNT(session_id) AS session_count
FROM sys.dm_exec_sessions
GROUP BY login_name,nt_user_name;
select client_net_address,local_net_address,count(*) from sys.dm_exec_connections group by client_net_address,local_net_address
select host_name,count(*) from sys.dm_exec_sessions group by host_name
select host_name,count(*) from sys.dm_exec_sessions group by host_name
--