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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
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:
    767
    Peter Row
    Oct 28, 2003
  2. SStory
    Replies:
    3
    Views:
    978
    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:
    811
    Liddle Feesh
    Jun 28, 2004
  4. CT
    Replies:
    1
    Views:
    429
    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,441
    shriop
    Feb 6, 2006
  6. Lulu
    Replies:
    2
    Views:
    392
    Otis Mukinfus
    Mar 17, 2006
  7. Guest
    Replies:
    1
    Views:
    345
    Cowboy \(Gregory A. Beamer\)
    Oct 18, 2006
  8. Gum

    Converting code ADO VBA to ADO net VB.net

    Gum, Aug 19, 2009, in forum: Microsoft ADO .NET
    Replies:
    2
    Views:
    1,326
    Scott M.
    Aug 19, 2009
Loading...