sql server 2008 r2查看并发连接数

sql server 2008 r2查看并发连接数

select hostname,COUNT(*) as zongshu,loginame,program_name from sys.sysprocesses
group by hostname,loginame,program_name
order by zongshu desc

select waittime,hostname,PROGRAM_NAME,hostprocess,loginame,login_time,status from sys.sysprocesses
where program_name in ('Internet Information Services','PHP')