SSRS and manually purging the ExecutionLogStorage table

Question

In SSRS, is it allowable to delete records from the [ReportServer].[dbo].[ExecutionLogStorage] table manually?

In a situation where the ExecutionLogDaysKept option has been set to -1 (keep all records), the accumulation of historic data may cause the ExecutionLogStorage table to become quite large. This can affect performance and take up significant storage. To reduce the number of records in this table, without changing to the ExecutionLogDaysKept parameter, could older data be deleted manually?

For example, delete all entries over 1,000 days old.

DELETE FROM [ReportServer].[dbo].[ExecutionLogStorage] WHERE TimeStart < DATEADD(day,-1000,GETDATE());

Is this allowable, or would it cause integrity issues for the application?

Thanks

Gordon

Answer 1

See stored ExpireExecutionLogEntries; I would say, deleteing directly from ExecutionLogStorage should work without any side effects.

Answer 2

Hi @Gordon Lederman

By default, log entries are kept 60 days. Why don‘t you set the ExecutionLogDaysKept back to 60 days
Refer to：https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-executionlog-and-the-executionlog3-view?view=sql-server-ver15

Best Regards,
Isabella

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.