How to find a Active Sql Connections

Hi In this post we are going to see how to find the active sql connections are there in server, sometimes the connection pool will get full and returns us a error like connection timeout. to find which are there for active connections.

select

    db_name(dbid) as [DbName],

    count(dbid) as [NoOfConnections],

    loginame as [LoginName]

from sys.sysprocesses

where  dbid > 0

group by

 dbid, loginame

From this post you can learn how to find the active sql connections.