Export (0) Print
Expand All

Report Server Execution Log

SQL Server 2000

The report server execution log contains information about the reports that execute on the server or on multiple servers in a single Web farm. You can use the report execution log to find out how often a report is requested, what formats are used the most, and what percentage of processing time is spent on each processing phase.

The following list describes the data that is captured in the report execution log:

  • Name of the report server instance that handled the request.
  • Report identifier.
  • User identifier.
  • Request type (either user or system).
  • Rendering format.
  • Parameter values used for a report execution.
  • Start and stop times that indicate the duration of a report process.
  • Percentage of time spent retrieving the data, processing the report, and rendering the report.
  • Source of the report execution (1=Live, 2=Cache, 3=Snapshot, 4=History).
  • Status (either rsSuccess or an error code; if multiple errors occur, only the first error is recorded).
  • Size of rendered reports in bytes.
  • Number of rows returned from queries.
Viewing Log Information

The report server logs data about report execution into an internal database table. This table does not provide complete information by itself, nor does it present data in a format that is understandable to users.

To view report execution data, you must run a DTS package that Reporting Services provides to extract the data from the execution log and put it into a table structure that you can query. For more information, see Querying and Reporting on Report Execution Log Data.

Managing Log File Content

You can turn report execution logging on or off by selecting options in Report Manager on the Site Settings page. On this page, you can also specify how long you want to keep log entries. By default, this value is 60 days. Entries that exceed this date are removed at 2:00 A.M. every day.

See Also

Checking Reporting Services Log Files

Reporting Services Error Messages

© 2015 Microsoft