open connections using ado.net

Discussion in 'Microsoft ADO .NET' started by Pat Capozzi, Oct 2, 2003.

  1. Pat Capozzi

    Pat Capozzi Guest

    We have built a web app which we subjected to a stress
    test after which we checked sql server Management -
    Current

    Activity - Process Info and found quite a few open
    connection that were taggedd "sleeping" and "awaiting
    command".

    Does this mean these are "orphaned connections"? We have
    meticiously closed our data table connections in the data

    layer and the data readers after we finished with them in
    the app.

    Thanks for the help on this.

    PatC
     
    Pat Capozzi, Oct 2, 2003
    #1
    1. Advertisements

  2. Pat,

    What you are seeing is because of "Connection pooling" that is On by default for all .NET Data Providers. As long as the process that created the pool is still alive, the pool
    will remain alive. Closing a connection will not remove the physical connection, it would send it back to the pool to be available for other Connection requests.

    So in a web App, the IIS process (DLLhost or Inetinfo) remain alive even after closing the App. If after calling iisrest or recycling iis, the connections remain there then there is
    a problem. If they disappear then you are OK.

    I hope this helps!


    Thanks,
    Hussein Abuthuraya
    Microsoft Developer Support

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Are you secure? For information about the Microsoft Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
    http://www.microsoft.com/security.
     
    Hussein Abuthuraya[MSFT], Oct 2, 2003
    #2
    1. Advertisements

  3. Pat Capozzi

    pat capozzi Guest

    Thanks,That helps tremendously. I reset IIS and they went away so I am
    assuming that they are not orphan connections.

    PatC


    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    pat capozzi, Oct 3, 2003
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Peter Row

    newbie vb6 ADO to vb.net ado.net, paging

    Peter Row, Oct 27, 2003, in forum: Microsoft ADO .NET
    Replies:
    2
    Views:
    465
    Peter Row
    Oct 28, 2003
  2. SStory
    Replies:
    3
    Views:
    723
    Bob Grommes
    Nov 14, 2003
  3. Liddle Feesh

    VB.net/ADO.net ADO Wrapper....

    Liddle Feesh, Jun 27, 2004, in forum: Microsoft ADO .NET
    Replies:
    2
    Views:
    504
    Liddle Feesh
    Jun 28, 2004
  4. CT
    Replies:
    1
    Views:
    207
    Sahil Malik
    Mar 21, 2005
  5. Kay-Christian Wessel

    Serialized ADO.NET 1.0 dataset compatible with ADO.NET 2.0

    Kay-Christian Wessel, Feb 1, 2006, in forum: Microsoft ADO .NET
    Replies:
    5
    Views:
    1,113
    shriop
    Feb 6, 2006
Loading...

Share This Page