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.
Thanks for Sharing.
ReplyDeleteDot Net Training in chennai
I personally feel that providing detailed blog posts is good but providing solutions to database problems in a code snippet is great.
ReplyDeleteSQL Server Load Soap API
Very rapidly this web page will be famous amid all blogging and site-building users, due to its pleasant articles or reviews Spot on with this write-up, I truly believe that this site needs a great deal more attention. I’ll probably be back again to read more, thanks for the info!
ReplyDeleteBCom 2nd Year Exam Admit Card 2021 | BCom 3rd Year Exam Admit Card 2021.