[筆記]查詢SQL SEVER連線數

select  db_name(dbid) , count(*) 'connections count'
from master..sysprocesses
where 1=1
and spid > 50
group by  db_name(dbid)
order by count(*) desc