How do I get the number of available connections?

• jordiserres

  Grasshopper

  Points: 24

  More actions

  November 17, 2015 at 3:44 am

  #302311

  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.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736297

  More actions

  February 12, 2016 at 8:42 am

  #1858394

  sys.database_connection_Stats

  http://blogs.msdn.com/b/wayneb/archive/2012/11/02/introducing-sys-database-connection-stats-for-troubleshooting-windows-azure-sql-database.aspx

  Maybe a count from here, wanting this to be > 2 (one will be your connection)

• jordiserres

  Grasshopper

  Points: 24

  More actions

  February 12, 2016 at 10:46 am

  #1858454

  Thanks you, Steve!