Events for a Report Server in SharePoint Integrated Mode
SharePoint Foundation 2010 and SharePoint Server 2010 offer diagnostic logging to monitor activity on a SharePoint server. If you run a report server in SharePoint integrated mode and have configured your reporting environment with SharePoint Foundation 2010 or SharePoint Server 2010, you might find some of the SharePoint events useful in monitoring your reporting environment. You can configure these events to be logged to the Windows event log or trace logs, or both. For more information and steps to configure diagnostic logging on a SharePoint server in SharePoint 2010 Central Administration, see Configure diagnostic logging settings (Windows SharePoint Services).
The following table lists event categories and levels that are recommended for monitoring a Reporting Services environment.. When an event is logged, each entry includes the time the event was logged, the process name, and the thread ID.
Logs events that involve database access.
Logs events that involve access to the following items:
Office Server General
Logs logon failures.
Logs current user information.
Logs events that involve access to the Report Viewer Web Part.
Starting with version SQL Server 2008 R2, there are Reporting Services specific categories supported for SharePoint diagnostic logging
The following categories will log information with a product area of 'SQL Server Reporting Services':
Logs calls made by the reporting services pages in SharePoint central administration.
Logs calls made by client applications to the report server.
Local Mode Processing
Logs calls made by the reporting services processing engine while in local mode.
Local Mode Rendering
Logs call made by the reporting services rendering engine while in local mode.
Soap Client Proxy
Logs calls made by the reporting services web pages or report viewer web part, to the report server.
Logs calls made by non configuration related pages within the SharePoint user interface.