Clearing the ASPStateTempSessions table

The ASP.NET async session state provider automatically cleans up the database table and removes old sessions. However, you can also clear expired session data manually, by removing the ASPStateTempSessions data from the database table.

Note: 
  • Only the system administrator can access these features. These features are not available in Oracle environments.
  • You can truncate a table to remove all the data from the table. This data cannot be recovered.

To clear expired session data from the ASPStateTempSessions table:

  1. Select Execute Query from the Tools menu. See Execute query.
  2. Specify the DELETE FROM ASPStateTempSessions WHERE Expires < GETUTCDATE() information in the Query field.
  3. Click the Execute option to run the SQL script for the database.
    Note: You can use the Test option to only test the SQL without modifying the data.
  4. Click Yes to confirm the deletion.
  5. Click OK.