SqlServer性能问题，查看有多少客户端链接

一、使用sp_who与sp_who2

sp_who

可以查看所有的当前连接

sp_who + 登录名

可以查看该登陆名下的所有连接

根据获取的host_name，就可以知道所在IP是多少了

ping WIN-BE48F4LV6VL -4

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.blocking_session_id, req.total_elapsed_timeFROM sys.dm_exec_requests req (NOLOCK)CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext;

SELECT * FROM sys.sysprocesses;

EXEC sp_who2;

二、sys.sysprocesses查看会话

select spid,db_name(dbid) as DBname,login_time ,last_batch ,status ,hostname ,program_name ,loginame from sys.sysprocesses where spid >50and loginame <> 'DESKTOP-ABCD\Administrator'--and dbid in (select dbid from master.dbo.sysdatabases where name ='要查询的数据库名称')order by last_batch desc

select spid,db_name(dbid) as DBname,login_time ,last_batch ,status ,hostname ,program_name ,loginame

from sys.sysprocesses

where spid >50

and loginame <> 'DESKTOP-ABCD\Administrator'

--and dbid in (select dbid from master.dbo.sysdatabases where name ='要查询的数据库名称')

order by spid

原文地址：https://blog.csdn.net/m0_37782300/article/details/105736425

三、使用Sys.dm_exec_Sessions与Sys.dm_exec_connections视图

select Session_id as spid, connect_time,client_net_address '客户端IP',local_net_address '服务器的IP' from sys.dm_exec_connections

select distinct host_name from sys.dm_exec_Sessions

根据获取的host_name，就可以知道所在IP是多少了

ping WIN-BE48F4LV6VL -4

select distinct login_name from sys.dm_exec_Sessions

原文地址：http://t.zoukankan.com/gered-p-10057774.html