How to check MSSQL Number Of ActiveConnections

How to check active connections in sql server, SQL server active connections, SQL server  connections, SQL server list active connections, SQL server view active connections

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




DB_NAME(dbid) as DBName,

COUNT(dbid) as NumberOfConnections,

loginame as LoginName




dbid > 0


dbid, loginame


Click Here!

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

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

How to change RDS MSSQL Database Name

  • Comments
  • 0

Sign up for Newsletter

Sign up to get our latest exclusive updates, deals, offers and promotions.