Check the total number of active connections on the MSSQL Database server

Please use the query below to check the total number of active connections at a time, on the MSSQL database server :-

#################################################################

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

]]>