以下示例返回连接到服务器的连接数，并显示起始 IP 地址和各连接的端口。SELECT session_id, client_net_address, client_tcp_portFROM 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
--