论坛 › SQL Server › SQL Server查看当前连接

alonli 发表于 2016-10-31 05:10:17

SQL Server查看当前连接

--查看当前连接数量
SELECT * FROM master..sysperfinfo where object_name = 'SQLServer:General Statistics' And counter_name = 'User Connections'

　　

--查看连接明细
Use Master
SELECT c.session_id, c.connect_time,s.login_time, c.client_net_address,
s.login_name,s.status
FROM sys.dm_exec_connections c left join sys.dm_exec_sessions s
on c.session_id = s.session_id
　　

-- 关闭连接
kill
kill 51
　　

查看完整版本: SQL Server查看当前连接