Report Server Administration - Professional SQL Server 2005 Reporting Services - page 479

❑ Data retrieval time, which is the time (in milliseconds) spent executing the query.

❑ Processing time, which is the time (again in milliseconds) spent processing the report — includ-

ing calculating subtotals, applying grouping and sorting, and so on.

❑ Rendering time, regardless of the rendered format.

❑ Source, which is the source of the rendered report. This may include processing reports using

live data, cached, snapshot, or history report sources.

Reporting Services stores this data in the ExecutionLog table in the ReportServer database. Because the
data in the table isn't easy to understand in raw form, an Integration Services package is provided to
export the log data to another location for viewing. You can also use SQL Server Agent to schedule the
Integration package to run according to a predefined schedule.

Three other main log files are maintained by Reporting Services. The default folder location for these
files is:

C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ LogFiles

The log files contain information about errors, warnings, and events for different Reporting Services
components. The name and description of these files are listed in the following table:

Log File Description

Contains logged information about the
Reporting Services Web service.

ReportServerService_<timestamp>.log

Contains logged information about the
Report Manager web application.

ReportServerWebApp_<timestamp>.log

Contains logged information about the
Report Server processing engine.

ReportServer_<timestamp>.log

Adjusting Execution Log Settings
The ReportingServicesService.exe.config file contains settings that configure how tracing is per-
formed. By default, the file is located in:

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

Here's a sample of the XML content you'll find in this file:

<configuration>
<configSections>
<section name=”RStrace”
type=”Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.Repor
tingServices.Diagnostics” />
</configSections>
<system.diagnostics>
<switches>