Tuesday, July 27, 2004

VJs Tip Of The Day - July 27th 2004

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???

So, there has to be a mechanism to clean this data every once in a while right!!... And ofcourse 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...

PS: To visit earlier tips click on the right side "Archives" menu of the blog site...

No comments: