Large jumps in number connections to SQL DB and Connection Pool

  • Thread starter Thread starter b1llybar00
  • Start date Start date
B

b1llybar00

Not really sure if I have a problem or not...but, I want to try and
understand what is going on. With that said, I haven't ruled out that
it's a code problem, but I want to post to see if anyone has seen
similar behavior.

Basically, throughout the day, we may see "large" jump in the number of
connections to our SQL DB and a corresponding jump in the connection
pool within a short period of time, i.e., 100+ connection increase in 2
to 3 seconds. The number of users during these jumps are steady...that
is, we don't have a large increase of end users (it's an internal call
center app).

Like I said, I haven't ruled out there being some kind of problem in
the application that generates the connections, but I just want to try
and persue all avenues.

Thanks in advance.
 
Crud, forgot one other fact...the connections that get added show up as
"idle"...that is, they aren't doing any active work.
 
Thanks for the question...no...we have been cleaning up our code so
that we do close them properly. There were instances where connections
were being created and not closed. We'll have those resolved
today...it will be interesting to see what happens tomorrow.
 
Back
Top