Sharepoint
United States (English) Sign in
Home Online 2013 2010 Other Versions Related Products Library Forums Gallery
TechNet Library
SharePoint Products and Technologies
SharePoint 2013
Technical reference
SharePoint Health Analyzer rules reference
A State Service Application has no database defined
Accounts used by application pools or service identities are in the local machine Administrators group
All State Service databases are paused for a State Service Application
Alternate access URLs have not been configured
Application pools recycle when memory limits are exceeded
Business Data Connectivity connectors are currently enabled in a partitioned environment
Cached objects have been evicted
Content databases contain orphaned Apps
Critical state of this rule indicates that the Word Automation Services is not running when it should be running
Database has large amounts of unused space
Databases exist on servers running SharePoint Foundation
Databases require upgrade or not supported
Databases running in compatibility range, upgrade recommended
Databases within this farm are set to read only and will fail to upgrade unless it is set to a read-write state
Databases used by SharePoint have outdated index statistics
Dedicated crawl target configuration has one or more invalid servers
Distributed cache service is not enabled in this deployment
Drives used for SQL databases are running out of free space
Expired sessions are not being deleted from the ASP.NET Session State database
Firewall client settings on the cache host are incorrect
Immediate translations for the Machine Translation service are disabled
InfoPath form library forms cannot be filled out in a Web browser
InfoPath Forms Services forms cannot be filled out in a Web browser because no State Service connection is configured
More Cache hosts are running in this deployment than are registered with SharePoint
One of the cache hosts in the cluster is down
One or more servers is not responding
One or more web applications are configured to use Windows Classic authentication
People Search relevance is not optimized when the Active Directory has errors in the manager reporting structure
Product / patch installation or server upgrade required
Search - One or more crawl databases may have fragmented indices
Some content databases are growing too large
The Application Discovery and Load Balancer Service is not running in this farm
The InfoPath Forms Services Maintenance Timer Job not enabled
The Machine Translation Service is not running when it should be running
The number of Distributed Cache hosts in the farm exceeds the recommended value.
The Security Token Service is not available
The settings for the Machine Translation Service are not within the recommended limits
The settings for Word Automation Services are not within the recommended limits
The State Service Delete Expired Sessions timer job is not enabled
The timer service failed to recycle
The unattended Service Account Application ID is not specified or has an invalid value
The Visio Graphics Service has a maximum cache age setting that will adversely impact performance
The Visio Graphics Service has a maximum cache size setting that may adversely impact performance
The Visio Graphics Service has a maximum recalculation duration setting that will adversely impact performance
The Visio Graphics Service has a maximum Web Drawing Size setting that will adversely impact performance
The Visio Graphics Service has a minimum cache age setting that may cause a security issue
The Visio Graphics Service has a minimum cache age setting that will adversely impact performance
This Distributed Cache host may cause cache reliability problems
Validate the My Site Host and individual My Sites are on a dedicated Web application and separate URL domain
Verify each User Profile service application has a My Site host configured
Verify each User Profile Service Application has an associated Managed Metadata Service Connection
Verify each User Profile Service Application has an associated Search Service Connection
Verify that OAuth is configured correctly for the Machine Translation Service application
Verify that OAuth is configured correctly for the Machine Translation Service application proxy
Verify that the Activity Feed Timer Job is enabled
Verify that the critical User Profile Application and User Profile Proxy Application timer jobs are available and have not been mistakenly deleted
Web Applications using Claims authentication require an update
Web.config file has incorrect settings for the requestFiltering element
Web.config files are not identical on all machines in the farm
XLIFF translations for the Machine Translation Service is disabled
Expand Minimize
2 out of 5 rated this helpful - Rate this topic

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

SharePoint 2013

Published: July 16, 2012

Summary: Learn how to resolve the SharePoint Health Analyzer rule "Expired sessions are not being deleted from the ASP.NET Session State database."

Applies to:  SharePoint Foundation 2013 | SharePoint Server 2013 

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.

    ImportantImportant:

    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 the Services snap-in, start the SQL Server Agent service.

Change History

Date Description

July 16, 2012

Initial publication

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.