How to check MSSQL Number Of ActiveConnections

First you need to open the SSMS.

1. Start search SSMS.
2.Open the SQL Server management studio.
3.Then connect to the sql server you want check he number of connections
4. Open New Query window.
5.Copy and Paste the below select statement

Statement:

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

Click Here!

Now you can see the number of active connections in output window.

Please click on follow and put the suggestions in the comment section. Thanks.