過期的工作階段將不會從 ASP.NET 工作階段狀態資料庫中刪除 (SharePoint Server)Expired sessions are not being deleted from the ASP.NET Session State database (SharePoint Server)

摘要: 了解如何解決 SharePoint Server 2016 和 SharePoint 2013 的 SharePoint Health Analyzer 規則「ASP.NET 工作階段狀態資料庫中的過期工作階段不會刪除」。Summary: Learn how to resolve the SharePoint Health Analyzer rule "Expired sessions are not being deleted from the ASP.NET Session State database", for SharePoint Server 2016 and SharePoint 2013.

規則名稱: ASP.NET 工作階段狀態資料庫中的過期工作階段不會刪除。Rule Name: Expired sessions are not being deleted from the ASP.NET Session State database.

摘要: 如果未刪除過期工作階段,主控 ASP.NET 工作階段狀態資料庫的伺服器可能會用盡磁碟空間,導致 SharePoint 伺服器陣列停止運作。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:

  • 已停止 SQL Server Agent 服務。The SQL Server Agent service was stopped.

  • 已安裝 SQL Server Express。SQL Server Express is installed.

    重要

    您無法在 SQL Server Express 的執行個體上執行 SQL Server Agent 服務。You cannot run the SQL Server Agent service on an instance of SQL Server Express.

解決方案:啟動 SQL Server Agent 服務Resolution: Start the SQL Server Agent service

  1. 確認執行此程序的使用者帳戶為主控 ASP.NET 工作階段狀態資料庫之資料庫伺服器的管理員群組成員。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. 在 [SQL Server 組態管理員]**** 中,啟動 [SQL Server Agent 服務]。*In *SQL Server Configuration Manger, start the SQL Server Agent service.