Display concurrent connection in SQLServer

SELECT DB_NAME(dbid) AS DBName,COUNT(dbid) AS NumberOfConnections,loginameFROM    sys.sysprocessesGROUP BY dbid, loginameORDER BY DB_NAME(dbid)