title: How to check current pool size of SQL Server
body: <p>Is there a way to check the current connection pool size in SQL Server? I am not talking about the max connection pool size, but the current pool size. Let's say the max pool size is 100 and there are 49 connections open, it should now show me either 51 available or perhaps 49 consumed.  </p>
  
  <p>So, is there such a query?</p>