sql 中的 ASP.NET session 状态

Question

我们用sql server来存储asp.net的session，我看ASPState数据库中的ASPStateTempSessions表是空的，请问是不是session过期了这个表的记录就被删除了？那里的记录什么时候会被删除？

Answer 1

The InstallSqlState.sql script creates a job called ASPState_Job_DeleteExpiredSessions to delete expired sessions from tempdb. Recall that ASP.NET does not keep session resources alive indefinitely. To support this feature when a SQL Server is used to maintain state, the SQL Server Agent must be running so that the expired session deletion job runs as needed. By default, the job is scheduled to run every minute. It deletes session state rows with an Expires value less than the current time. The account under which the SQL Server Agent runs must have the privilege to execute the DeleteExpiredSessions stored procedure.

请引用this one