Maximum connection is connection pool reached. How to solve this ?

[sweth]

We have an asp.net / sql server application which is ASP model and needs dynamic connection switching to go to different dbs based on client login. And i found recently maximum connection of pool reached after a week of continous run.
How to identify unwanted connections in sql server and reset them.

 

[SQLDenis]

sp_who2 will list all the connections with their spid
use DBCC INPUTBUFFER (SPID) to identify the SQL statements

KILL SPID to 'kill' them

Nota Bene
SPID's between 1 and 50 are for SQL Server itself, do NOT kill those



“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[yelworcm]

Check the code for your application, as well. We had a similar situation come up here, when someone forgot to include a connection close statement on their page.