Reporting Services Log Viewer

  • Article

Ever wondered How to analyse the Logs that are gathered in SQL Server Reporting Services?. There is a "Reporting Services Log Viewer" Which enables you to analyse, trouble shoot and understand what's happening inside the SSRS and who and what reports are executed, time consumed for execution, Amount of Data being processed.

The sample demonstrates how to read and analyze the Reporting Services trace logs and the Report Server execution log data. The sample does the following:-

•Trace logs record report execution activity and the environment variables that are in effect during report processing. Errors and exceptions are also entered into trace logs. The sample helps us identify the frequency of the errors and exceptions logged in the trace logs.

•Provide tips to fix any errors logged in Logfiles.

•Describe the ExecutionLog columns, with tips on how to interpret values.

•Interpret the ExecutionLog2.AdditionalInfo and some interesting pieces of information it provides.

•Provide tips to analyze ExecutionLog2 information.

•Provide tips to optimize reports.