1
Posted on 8:21 AM by Softminer and filed under

one of common problems in Sql serverl is pool over because of open connections are not closed.

sp_who2 will help you to see open connections to your SQL database engine.

this is screenshot of the result of the run



SELECT @@MAX_CONNECTIONS AS 'Max Allowed Connections'

to have select query on sp_who to see the connection of specific database



SELECT SPID,

STATUS,

PROGRAM_NAME,

LOGINAME=RTRIM(LOGINAME),

HOSTNAME,

CMD

FROM MASTER.DBO.SYSPROCESSES

WHERE DB_NAME(DBID) = 'DB_Name' AND DBID != 0
1
Response to ... Show number of active database connections in SQL Server
Anonymous said... December 6, 2011 at 3:27 AM

Nice Thanks


Computech