PC Review

Thread Tools Rate Thread

open connections using ado.net

Pat Capozzi
Posts: n/a
      2nd Oct 2003
We have built a web app which we subjected to a stress
test after which we checked sql server Management -

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

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.

Reply With Quote
Hussein Abuthuraya[MSFT]
Posts: n/a
      2nd Oct 2003

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!

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

Reply With Quote
pat capozzi
Posts: n/a
      3rd Oct 2003

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Network Connections no longer showing LAN connections Baz Windows XP Help 2 7th Nov 2004 04:36 PM
Network Connections not displaying any connections psychme Windows XP Networking 2 2nd Jan 2004 10:12 PM
>My Network Connections window does not have anything called Incoming Connections lhd_5113 Windows XP Networking 1 26th Nov 2003 09:08 AM
Why can't I find Incoming connections in My Network Connections? NormC Windows XP Networking 1 24th Nov 2003 03:57 AM
Can't see network connections in network connections folder DTP Windows XP Networking 1 12th Aug 2003 09:37 PM




All times are GMT +1. The time now is 10:09 PM.