I have troubles with a threaded application on W2003 server. It seems
to leave open connections behind time to time, it sums to hundreds over
a day (the application make thousands). It is using the SQLOLEDB
provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2
(3790).
I put two Trace (print) statements for testing: (1) Connection is
opened. 2) Connection is Closed.) I can see the two statements without
any Exception. But the problem is when I see on the Performance viewer
(perfmon.exe/ perfmon.msc->Sqlserver:General Statistics, User
Connections) it shows Number of users connected to the system is like
thousands and more day by day ,Means the number of open connections are
in Hundreds...thousands and more . I am also loosing the connections
immediately with out any exception.But still I am seeing open
connection.
Please can anybody sort out my problem,
Is there a known bug like this? Is there a way to trace the SQLOLEDB
provider?
Re: service soemtime will get slower -- what to watch ... I bet that after a couple of days you have a BIG number of connections open and that is the problem you are seeing. ... Not just client initiative the conversation, sometime the srever will actively send data to client,and then client response as well. ... And the conversation between client and server has to be "real time". ... see how many open connections you have. ... (microsoft.public.dotnet.languages.csharp)
Re: service soemtime will get slower -- what to watch ... I bet that after a couple of days you have a BIG number of connections open... The client connect to the server in ...Server) thought TCP/IP socket in a local 100M LAN. ... see how many open connections you have. ... (microsoft.public.dotnet.languages.csharp)
Re: Strange Message on Shutdown...! ... If you are nervous about someone watching you on a network, ... want to see if there are any open connections to your machine. ... all windows associated with network connectivity (AIM/Internet Explorer ... (microsoft.public.windowsxp.basics)
Re: Connection Leak. ... Why use SQLOLEDB?...connections or close them when the application is done with them. ... Hitchhiker's Guide to Visual Studio and SQL Server... thousands and more day by day,Means the number of open connections are ... (microsoft.public.dotnet.framework.adonet)
SSH 3.2.0: Too many open connections --- how to check whats open? ... The maximum number of connections is set to 50. ... But netstat showed at that time only seven open connections.... And would it be safe to simply restart sshd2 to get rid of "zombie"... (comp.security.ssh)
