Short description to change execution log expiration settings. SSRS execution log is good tool to monitor reports activity. When using it you can find that the data are not stored forever. The default time period for which the data are stored in Reporting Services database are 60 days. If you would like to change this setting, follow these steps.
Open SQL Management Studio and connect to Reporting Services by selecting Server type to Reporting Services and select your server name.
When connected to the server go to Object Inspector, obviously place on left side in Management Studio, go to Report Server name at the top and right click to get Popup menu.
Go to Properties to get Server Properties window. Here you can see set of Reporting Services settings you can change from Management Studio. If you look at the first section, General, thee is URL address for report server (it is available in Reporting Services Configuration manager too). The name of instance is visible when you go to Reporting Services Manager at the top of the web interface. You can change it here.
But we would like to change Execution log settings so go to Logging section on the left menu.
Here we can set the number of days the data will be stored in execution log. Or if to disable Report Execution logging at all.
Reporting Services execution log. You will find it in Reporting Services database. There stored data regarding Reports and Users activity in Reporting Services repository. You can use it for user access monitoring or when you register problems with Report performance.
Execution log data are stored in ExecutionLogStorage table or you can access it better using view Dbo.ExecutionLog, dbo.ExecutionLog2, dbo.ExecutionLog3 where this table is joined with Catalog table. Here are briefly few interesting attributes which could suit you.
Report data processing – information you need to get when resolving performance issues
Time the data are retrieved from dataset in Milliseconds (SQL query, SQL procedure, etc.)
Time the data are processed in report (Expressions, Groups, Sorting etc.)
Time the report spends with rendering (Pictures, rows, etc.)
Start of report processing
End of report processing
Report data retrieval – good to know how many rows are taken from datasets to report
Size of rendered report in bytes
Number of rows returned from datasets for report rendering
Additional information regarding report rendering, processing (for example, rendering extension.)
Source – it could be useful when tuning report performance. For example, if report data are already taken from cache.