Expired sessions are not being deleted from the ASP.NET Session State database (SharePoint Server)

APPLIES TO: 2013 2016 2019 Subscription Edition SharePoint in Microsoft 365

Rule Name: Expired sessions are not being deleted from the ASP.NET Session State database.

Summary: If expired sessions are not deleted, the server that hosts the ASP.NET Session State database may run out of disk space and the SharePoint farm may cease to function.

Cause: One or more of the following might be causing this:

• The SQL Server Agent service was stopped.

• SQL Server Express is installed.

  Important

  You cannot run the SQL Server Agent service on an instance of SQL Server Express.

Resolution: Start the SQL Server Agent service

1. Verify that the user account that is performing this procedure is a member of the Administrators group on the database server that is hosting the ASP.NET Session State database.

2. In SQL Server Configuration Manger, start the SQL Server Agent service.