Re: Out-of-process State Management Session Cleanup

the default session cleanup is a scheduled job with sqlagent. it runs at a specified interval and just deletes expired sessions. if you look at the proc its a pretty simple delete. you could replace it with you own job, that the the session cleanup and ran whatever other code you want.


-- bruce (sqlwork.com)


knyghtfyre@xxxxxxxxx wrote:
Hello,

My company is developing a rather large application with .NET 2.0. We
are expanding to a server farm and are in the process of converting
our application to use an out-of-process session state management with
SQL Server.

We have ran into a problem with the Session_onEnd event. We know it's
not supposed to fire when in an out-of-process mode, but we have a
large amount of code that must be executed to clean the session and to
log some critical data.

Are there any best practises for dealing with such a situation? What
have others done in the past that have helped them keep a session
state that times-out and cleans up afterwards? Is there a possibility
of the SQL Server to keep track of said timeout and execute some clean
up code?

I've been searching for a few days now and have not yet been able to
find any "best practises" for this type of situation, if you know of
any articles, or have any personal experience, any help is
appreciated.

Thanks,
Marc

.

Relevant Pages

  • performance consideration
    ... Every user is authonticated on each to a session value he received upon ... logging-on. ... users are logged out if they have invalid session value (hack ... values of the active users (with a scheduled job to clear out old sessions). ...
    (microsoft.public.sqlserver.programming)
  • Re: Out-of-process State Management Session Cleanup
    ... How critical is the last log on session info to the new login session for ... large amount of code that must be executed to clean the session and to ... state that times-out and cleans up afterwards? ... of the SQL Server to keep track of said timeout and execute some clean ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to clear the prolog database?
    ... clean, why don't you just close your session and start another? ... I actually want to seperate data into groups, so I can use which ever ... Wise lesson! ...
    (comp.lang.prolog)
  • Re: end session when the browser window is closed.
    ... My personal preference is to not tied clean up to the normal application ... for other session providers etc... ... > I want to do clean up routine to my database when the browser is closed. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Session_OnEnd not firing sometimes?
    ... "The greatest danger for most of us is not that our aim is too high and we miss it, but that it is too low and we reach it" Michelangelo ... CA> session and have its finalizer do the clear up? ... CA> is no reference to it in Session scope), my clean up will happen ... CA> What kind of scenarios would case Session_OnEnd not to fire? ...
    (microsoft.public.dotnet.framework.aspnet)
Loading