Large jumps in number connections to SQL DB and Connection Pool

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.

b1llybar00
Thu Apr 28 22:35:01 CDT 2005

Sorry, forgot to mention...using ADO.NET with the .NET Framework v. 1.1

b1llybar00
Thu Apr 28 22:40:33 CDT 2005

Crud, forgot one other fact...the connections that get added show up as
"idle"...that is, they aren't doing any active work.

Val
Fri Apr 29 20:38:51 CDT 2005

Hi,

Do you close and dispose connections properly?

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"b1llybar00" <kevin_ebert@hotmail.com> wrote in message
news:1114745598.766160.247510@g14g2000cwa.googlegroups.com...
> 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.
>

b1llybar00
Tue May 03 10:11:17 CDT 2005

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.