Home Library Learn Samples Downloads Support Community Forums
This topic has not yet been rated - Rate this topic

Server Properties (Logging Page)

SQL Server 2012

Use this page to set limits on the report execution data that is collected by a report server. Execution data is stored internally in the report server database. You can track report activity for report server that runs in native mode or SharePoint integrated mode. If the report server is part of a scale-out deployment, the report execution log maintains a record of all report activity for the entire deployment in a single log file.

To open this page, start SQL Server Management Studio, connect to a report server, right-click the report server name, and select Properties. Click Logging to open this page.

Enable report execution logging

Click to create and store information about report activity on the server. If this option is enabled, the report server will track which reports are used, the frequency of report processing, the type of report operation that was performed, the output format, and who ran the report. For more information about additional data points that are captured in the log, see Report Server Execution Log and the ExecutionLog3 View.

Remove log entries older than this number of days

Specify the number of days after which log entries will be trimmed from the report execution log. The default value is 60 days.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.