这个查询很强吧.虽然sp_who也可以看到一些.但没有统计.这个有统计.呵呵.当然,可以改成一个视图.
select
CASE WHEN (GROUPING(hostname) = 1) THEN '_ALL' ELSE ISNULL(hostname, 'UNKNOWN') END AS hostname,
CASE WHEN (GROUPING(loginame) = 1) THEN '_ALL' ELSE ISNULL(loginame, 'UNKNOWN') END AS loginame,count(*) as count_spid
from master.dbo.sysprocesses with(nolock)
where hostname<>''
group by hostname,loginame with cube