Users do not get disconected

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike_T - 30 Oct 2006 08:34 GMT

Hi,

When detaching my db a msg came back skating that I have over 300
connections to it. I know at the moment I was the only one connected so, for
some reasons, user process ids are not recycled (or eliminated) when the
user disconnects from the db. Is this normal? If not, how do I ensure that
such ids are eliminated automatically?

TIA

Mike

Reply to this Message

Arnie Rowland - 30 Oct 2006 08:52 GMT

One possibility is application pooling. Normally a good thing, however,
users may be using Windows Authentication (or unique SQL authentication),
and the application pool is configured to hold a minimum number of
connections for an unlimited time duration.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

> Hi,
>
[quoted text clipped - 7 lines]
>
> Mike

Reply to this Message