maximum number of connections reached

Question

maximum number of connections reached

iwaldner

SSC Eights!

Points: 805
More actions
August 17, 2006 at 6:18 pm

#67778

We are begining to get "Maximum number of connections reached" errors... and sql server (2000) is refusing further connections.
We are definately not anywhere near 32,767..
What else would be generating this error?
Ilmar

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

VT-176769 SSChasing Mays Points: 637 More actions · Answer 1

Your application might not be closing the connection properly. run sp_who2 'active' or from Enterprise manager, Managment/Current Activity and click on Process Info which shows you all the connections to the server

chears

TheRedneckDBA SSChampion Points: 14001 More actions · Answer 2

I get this problem every now and then. I've pretty much narrowed it down to java apps (especially if the connections are managed by Tomcat) not closing connections properly.

The only ways to fix it I have found is to manually kill the processes, or occasionally bounce the Tomcat service late at night.

Niether solution is that good, but it happens infrequently enough that I haven't put much time into finding anything better.

The Redneck DBA

Gino-123103 SSC Enthusiast Points: 127 More actions · Answer 3

I have a similar issue, is there nothing to compare to mysql's wait_timeout or interactive_timeout ?

iwaldner SSC Eights! Points: 805 More actions · Answer 4

Thanks folks.. I'm begining to find places in the application framework that are leaving connections open... the hunt is on!