查看当前数据库的所有客户端链接情况:


select   hostname,count(*) hostconncount  from   master.dbo.sysprocesses
group by hostname order by count(*) desc