SQL Server 查询当前连接的数量

SELECT   DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName
FROM     sys.sysprocesses
WHERE    dbid > 0
GROUP BY dbid, loginame;