Access Services out of memory - Event 16 (SharePoint Server 2010)
Applies to: SharePoint Server 2010 Enterprise
Alert Name: Access Services out of memory
Event ID: 16
Summary: The Access Services in Microsoft SharePoint Server 2010 computer maintains sessions that hold query cache results, and performs other operations that use a lot of memory. The Access Services server computer is low on memory or is out of memory.
Symptoms: One or more of the following symptoms might appear:
Access applications in the Web browser time out or respond very slowly.
Users cannot load or view their Access Services applications in the browser.
This event appears in the event log: Event ID: 16 The ADS box <machine name> has run out of memory.
Cause: One or more of the following might be the cause:
The amount of memory consumed by Access Services in SharePoint on the back-end server computer has grown too large.
There is excessive traffic to the Access Services server computer and the computer cannot serve that many users.
Resolution: Restart Access Services
Consider whether you have enough Access Services server computers in the farm to support the number of users of your deployment. The addition of Access Services computers in your farm reduces the amount of traffic and memory requirements on any single Access Services computer.
Use the SharePoint Central Administration Web site to change the Maximum Session Memory setting for Access Services to a lower value.
On the SharePoint Central Administration Web site, on the Quick Launch, click Application Management, and in the Service Applications section, click Manage service applications. In the Type column, note that Access Services Web Service Application appears for Access Services applications.
In the Name column, click the Access Services application that is out of memory.
On the Manage Access Services page, in the Session Management section, type a lower value for Maximum Session Memory, and then click OK.
Restart the Access Services computer to free up memory and return the Access Services computer to a known good state.