Session Caching in MSDE

[Andrew Robinson]

I have a web site that is running with two web servers and a third server
running MSDE. I have successfully installed and am running with SQL based
Session.

How do I purge the ASPStateTempSessions table from time to time? It appears
that there might have been some type of automatic script that was run with
the full blown version of SQL under the Server Agent, but that does not
exist with MSDE.
Thanks,

[Bruce Barker]

msde does not support sqlagent, so the automatic job will not run. you just
need to run the purge proc manually.

exec ASPState.dbo.DeleteExpiredSessions

you could run it at appunload if you do not have a scheduler

-- bruce (sqlwork.com)

"Andrew Robinson" <ne****@nospam.nospam> wrote in message
news:%2***************@TK2MSFTNGP09.phx.gbl...

I have a web site that is running with two web servers and a third server
running MSDE. I have successfully installed and am running with SQL based
Session.

How do I purge the ASPStateTempSessions table from time to time? It
appears that there might have been some type of automatic script that was
run with the full blown version of SQL under the Server Agent, but that
does not exist with MSDE.
Thanks,

[Steven Cheng[MSFT]]

Hi Andrew,

I agree to Bruce's suggestion. The auto cleanup task in the ASP.NET
sqlservrer session reply on the SQL Agent service. so for MSDE which dosn't
contain such service, we need to manually execute the clean up job. If you
can use the windows's schedule task , then that'll be a good choice.
Otherwise, if you think it's necessary to put all the code in your
application scope, you may consider using a global Timer or background
thread to do the job in your asp.net app.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| From: "Bruce Barker" <br******************@safeco.com>
| References: <#c*************@TK2MSFTNGP09.phx.gbl>
| Subject: Re: Session Caching in MSDE
| Date: Mon, 1 Aug 2005 13:43:38 -0700
| Lines: 25
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Response
| Message-ID: <uQ**************@tk2msftngp13.phx.gbl>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: rdcsd1.safeco.com 12.144.134.2
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSF TNGP08.phx.gbl!tk2msftngp1
3.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl
microsoft.public.dotnet.framework.aspnet:115524
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| msde does not support sqlagent, so the automatic job will not run. you
just
| need to run the purge proc manually.
|
| exec ASPState.dbo.DeleteExpiredSessions
|
| you could run it at appunload if you do not have a scheduler
|
| -- bruce (sqlwork.com)
|
| "Andrew Robinson" <ne****@nospam.nospam> wrote in message
| news:%2***************@TK2MSFTNGP09.phx.gbl...
| >I have a web site that is running with two web servers and a third
server
| >running MSDE. I have successfully installed and am running with SQL
based
| >Session.
| >
| > How do I purge the ASPStateTempSessions table from time to time? It
| > appears that there might have been some type of automatic script that
was
| > run with the full blown version of SQL under the Server Agent, but that
| > does not exist with MSDE.
| >
| >
| > Thanks,
| >
|
|
|