Monitoring Connections

Greetings,

I have a CGI web application that is connecting to SQL2k sp3 server using a
system ODBC DSN to display data from tables on a web page.

These tables are being populated by another application that is using .net
SqlConnection object to insert data.

The problem I am seeing is that after a period of time the .net application
can no longer open a connection to the database. I believe this may be
because the connections that the CGI application is useing are not being
properly closed. When I use sp_monitor, I can see the number of Connections
increase each time the CGI application fires. My question here is:

-The BOL indicates that the connections field shown in the results from
sp_monitor show the 'number of logins or attempted logins'. It is kind of
difficult for me to understand from this whether or not I am correct in my
feeling that the CGI application is not closing the ODBC connections. For
instance, do 'attempted logins' count against the number of 'connections'
allowed?

Ive also opened a trace using Profiler and I note an Audit logout event for
each Audit Login event that occurs by the CGI Applicaiton, but how can I know
whether this connection has been properly closed so that I can predict
whether SQL Server will eventually prevent the .net application from
connecting to insert new data?

This instance in licensed by processor, by the way...

TIA

.

Relevant Pages

  • Re: Monitoring Connections
    ... CGI app, then I do see another row appear in the sp_who2 results. ... 'connections' field incrementing. ... >> sp_monitor show the 'number of logins or attempted logins'. ...
    (microsoft.public.sqlserver.connect)
  • Re: speeding up cgi perl
    ... rather than a CGI. ... multiple connections speed that up. ... Profile, profile, profile. ...
    (comp.lang.perl.misc)
  • Re: Monitoring Connections
    ... many open connections or not at any particular time. ... > I have a CGI web application that is connecting to SQL2k sp3 server using ... > sp_monitor show the 'number of logins or attempted logins'. ... > Ive also opened a trace using Profiler and I note an Audit logout event ...
    (microsoft.public.sqlserver.connect)
  • Re: XMLRPC Server
    ... of your CGI programs. ... related CGI programs had to open connections to database systems whose ... connection costs were very expensive. ... database systems. ...
    (comp.lang.python)
Loading