November 17, 2015 at 3:44 am
I am administering a web service connected to a bunch of databases.
From time to time, the connection pool gets empty.
I adressed the issue with try-catch blocks to prevent a connection being taken forever, but to make sure everything is fine, I'd like to know the number of available connections at any time.
Is there a way to do so?
Thank you.
February 12, 2016 at 8:42 am
sys.database_connection_Stats
Maybe a count from here, wanting this to be > 2 (one will be your connection)
February 12, 2016 at 10:46 am
Thanks you, Steve!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy