0
votes
2answers
278 views

monitoring the size of an SQL Server connection pool

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?
1
vote
1answer
2k views

Kill Leaking Connections on SQL Server 2005

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 ...