-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: VishalRJoshi
Message 15 in Discussion
SQL Server Session State Does It Again
Well did you wonder yesterday, that if your session data was stored in
permanent tables on SQL server and there would be "n" number of sessions
running for your application all the time how much data would get collected
in the SQL Server???... If you thought about it, I really appreciate...
So, there has to be a mechanism to clean this data every once in a while
right!!... And of course there is... When SQL Server support for session
gets installed a job to delete the expired session is also installed, this
job runs every minute and is called ASPState_Job_DeleteExpiredSessions...;
It requires SQLServerAgent service to be running in order to work...
Vishal Joshi
Microsoft MVP .Net
If You Think YOU CAN... You Can...
http://VishalJoshi.Blogspot.com
http://www.microsoft.com/india/mvp/indiamvp.aspx
http://groups.msn.com/ChennaiNetUserGroup
http://groups.msn.com/CNUG-DAM
http://groups.msn.com/NetBloomingtonUserGroup
PS: To visit earlier tips click on the right side "Archives" menu on my blog
site...
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you received
this message by mistake, please click the "Remove" link below. On the pre-addressed
e-mail message that opens, simply click "Send". Your e-mail address will be deleted
from this group's mailing list.
mailto:[EMAIL PROTECTED]
