Get Number of Active Connections to Database in SQL Server

Get Number of Active Connections to Database in SQL Server 

sp_who or sp_who2

 

 

If we want to see only active connections for specific database we need to write the query like as shown below

SELECT SPID,STATUS,PROGRAM_NAME,LOGINAME,HOSTNAME,CMD

FROM MASTER.DBO.SYSPROCESSES WHERE DB_NAME(DBID) = 'your database name' AND DBID != 0