SSRS: Report Server Usage Report

SSRS: Report Server Usage Report

While working with SSRS (SQL Server Reporting Service) it is very common to look into the Execution log to understand the usage pattern of the report that are deployed or to troubleshoot the performance issues.SSRS stores the detailed execution plan in a table named ExecutionLog which resides in the SSRS repository database.

Below script will give you the details of report execution in last 24 hours.

• Path : Report path in the the reports manager
• Name : Report Name
• Request Type :This tells you how the report got executed . Interactive is the manual execution of the report using the report manager or a custom UI. Report executed as part of scheduled subscription will have value subscription for this column.
• Format : The rendering format
• TimeStart : Report process start time
• TimeEnd : Report process end time . The difference between the TimeStart and TImeEnd gives you the total duration of the request.
• Data Retrieval time (Sec) : The number of seconds spent on data sources and data extenstions in main report and all of its subreports. If the multiple data source are accessed parallel, this will be be the duration of the longest data set duration.If the data sources are accessed sequentially, this will be the sum of all data set duration.
• Processing Time (Sec) : The number of seconds spent in the processing the request. This include report processing bootstrap time and processing time for grouping,sorting,filtering ,aggregation ,subreport processing etc.
• Rendering Time : The number of seconds spent on rendering extension.This includes time spent on rendering, pagination module, on demand expression evaluation etc.
• Source :Specifies the type of execution.
  • Live : data set queries are executed to get the result
  • Cache: Reports is generated based on the data in the cache. Data set queries are not excuted
  • Session :Subsequent request with an existing session .For example, initial request to view the report and subsequent request is to export to pdf.
  • RDCE: Indicates Report Definition Customization Extension, that can dynamically customize a report definition before it is passed to the processing engine during the report execution
• Status : Report execution status . rssuccess denote the success of report execution.
• Size(KB) : Number of Kb generated as output of this report execution request.
• Number of Records:Number of rows processed.

By execution log retention period is 60 days. If your environment requires a change on this value , you can modify this through the advanced page of report server properties after connecting the SSRS in the SSMS. Refer thetechnet page.The other option is change the value directly in the configuration table.