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.
From this post you can learn how to find the active sql 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.