We are trying to track down a performance issue. One theory we have is that we are running out of connections in the connection pool. Is there a way to monitor the size of a connection pool?
We have a legacy ASP application that somewhere leaks SQL Connections. In Activity Monitor, I can see a bunch of idle processes with Last Batch times over an hour old. When I look at the T-SQL ...