See stored ExpireExecutionLogEntries; I would say, deleteing directly from ExecutionLogStorage should work without any side effects.
SSRS and manually purging the ExecutionLogStorage table
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
1 additional answer
Sort by: Most helpful
-
Isabellaz-1451 3,611 Reputation points
2021-10-14T03:02:34.443+00:00 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-ver15Best 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.