Re: Ecommerce account is logged in for a long time on SQL Server

From: Joe Weinstein (joeNOSPAM_at_bea.com)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 09:44:49 -0800

jdnospam@hevanet.com wrote:

> I'm monitoring our SQL Server over the weekend to see what is happening
> with the Ecomm login account that allows nurses to renew licenses online.
> Using the standard trace template which has 2 events, "Audit Login" and
>"Audit Logout", I find that the average over the weekend for anything over 10 minutes is 70 minutes!
>
> SELECT AVG(Duration / 60000) AS AverageOfMinutesLoggedIn
> FROM AllNightStandardProfileForEcomm
> WHERE (Duration / 60000 > 10)
>
> Scratching my head here. Does that mean that the webserver (ecomm account
>using java and MS JDBC driver) logs in and stays logged in until the nurse
>is done? Is this done at the start of a sesssion? Does this make sense? In
> ADO connections you login, do the dirty deed, and then log out. Over and
>over. I'm thinking that the web people wrote the code to login at session
>start and logout at session end. Is that correct? I'm thinking no.
>
> It does take a while for a nurse to renew her license(s) because they have
>to put in all sorts of continuing education credits. One nurse took 265 minutes!
> And her session was logged in to the database the whole time.
>
> Any ideas, insites?

Hi. If the JDBC client is middleware, it may be pooling connections, which is a good thing.
However, if it's a simple client, then it may keep a connection for as long as it needs,
and if it's really poorly designed, it may start a transaction to do what the nurse wants,
and then hold the connection open and do updates as the nurse does, locking data till (s)he
finishes... Maybe the application could get a connection at the start to verify the DBMS
is up, then close it and collect all the data while *not* connected to the DBMS. Then,
when it's ready to submit, re-open the connection and do the update is one quick move.

Joe Weinstein at BEA
>
> John
>
> **********************************************************************
> Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Relevant Pages

  • Re: Ecommerce account is logged in for a long time on SQL Server
    ... > with the Ecomm login account that allows nurses to renew licenses online. ... > It does take a while for a nurse to renew her licensebecause they have ... However, if it's a simple client, then it may keep a connection for as long as it needs, ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: School belt. OhYAH!!
    ... >T N Nurse wrote: ... >> I always wondered what the connection with Lochgelly was. ... > Principal sources of employment in that town were the strap manufactory ...
    (soc.culture.scottish)
  • Re: Generic user names, am I the only One?
    ... My Compaq embedded NT has an "auto login" feature. ... Where can I find a "How To" for Kiosk Mode? ... Plus we dont have to set up nurse desktop and apps at every ... > machines are small drives. ...
    (microsoft.public.windows.server.active_directory)
Loading