Re: Monitoring Connections

Hi,

Thanks for the reply,

OK, Ive run sp_who2. If I run it at the same time as I make a request to the
CGI app, then I do see another row appear in the sp_who2 results. Then it
disappears a bit later when I re-run sp_who2.

At the same time, I am running sp_monitor and I see the value of the
'connections' field incrementing. Does this value have any relationship to
the number of currently opened connections? Does sp_who2?

Thanks

"Andrew J. Kelly" wrote:

> You can use sp_who2 to see how many connections are currently existing and
> who belongs to each. It will also show status of each connection as well
> but since it is a snap shot it may not be truly indicative of the overall
> connection. But you should be able to get an idea of if the GCI app has too
> many open connections or not at any particular time.
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Charlie" <Charlie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:A5FF4C6F-9E19-4B26-A070-4C0001F4C3EA@xxxxxxxxxxxxxxxx
> > 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: speeding up cgi perl
    ... rather than a CGI. ... multiple connections speed that up. ... Profile, profile, profile. ...
    (comp.lang.perl.misc)
  • Monitoring Connections
    ... system ODBC DSN to display data from tables on a web page. ... because the connections that the CGI application is useing are not being ... I can see the number of Connections ... sp_monitor show the 'number of logins or attempted logins'. ...
    (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)
  • 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: Too many sa failed logins
    ... > The event log is showing a ton of failed sa logins. ... I don't have a real answer to your question, but exposing a database server ... The best option for monitoring attempted connections would be at the ... OS or network level - if a client doesn't authenticate with MSSQL, ...
    (comp.databases.ms-sqlserver)