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.
Category |
Level |
Description |
|---|---|---|
Database |
Verbose |
Logs events that involve database access. |
General |
Verbose |
Logs events that involve access to the following items:
|
Office Server General |
Exception |
Logs logon failures. |
Topology |
Verbose |
Logs current user information. |
Web Parts |
Verbose |
Logs events that involve access to the Report Viewer Web Part. |
Report Server Diagnostic Categories
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':
Category |
Description |
|---|---|
Configuration Pages |
Logs calls made by the reporting services pages in SharePoint central administration. |
HTTP Redirector |
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. |
UI Pages |
Logs calls made by non configuration related pages within the SharePoint user interface. |