SQLServer 2005 识别连接到服务器的客户端

以下示例返回连接到服务器的连接数，并显示起始 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

-- 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 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

--