Assessing report performance and usage
SSRS introduces some interesting capabilities as we have been seeing through the previous chapters. Here is another interesting aspect to add to the list: SSRS report logs. SSRS reports log key usage parameters into the system automatically. The free Report Log Viewer tool can unravel a lot of useful production data that helps to understand which reports are being used, what is consuming a lot of time, and which reports fail. This recipe will throw some light on how to configure and use the log viewer for this purpose.
Getting ready
Download the SSRS report log viewer from http://www.microsoft.com/en-us/download/details.aspx?id=24774 and install it.
This tool will demonstrate the best way to analyze the Report Server Service Trace Log and Report Server Execution Log, which are useful if you are debugging an application or investigating an issue or event.
How to do it…
The Report Log Viewer is installed by default in the following location:
Program Files...
