Follow

Size issues with your repository Clean up the logs and get more space

Clean logs in the repository

Sometimes the repository database become very large. This is normally due to the logs. Thankfully there is some ways to remove old data.

Clean the execution log

It can be removed from the logs in the Repository Administration Tool. A period needs to be chosen as well. Ideally choose every thing until the first of January of the current year.

When a period have been chosen, it shows you the data and projects. It is possible to specify what project is used as well.

To select all of them. Start by marking the bottom line, then go to the top line and mark that while pressing shift. Now press the check box and all lines are chosen and they can be deleted.

Other logs

We previously had a request where cleaning up the schedule logs were not enough. It was still too big. We have a system table database that is called sysssislog and it contains data regarding all executions where ssis is used and is one of the largest tables in the repository.

It is possible to shrink this as well, even though it is a more advanced job. I have a script that removes all fields not containing error messages.

delete from dbo.sysssislog where event <> 'OnError'

It just needs to be executed against your repository and it will remove all lines that does not contain error information.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

1 Comments

  • 1
    Avatar
    Rasmus Remmer Bielidt

    Thanks for the guide, it is very helpful.

    In our case it is not the database space that is the problem, rather the VERY long time taken to open up the execution log on objects that are frequently executed.

    How can this be set in a batch job?

    Is it enough to delete the obsoleted records in the following tables:

    ExecutionLogs
    ExecutionPackageLogs
    ExecutionPackageLogDetails
    LogRowCounts
    ScheduleJobs
    ScheduleJobLogs

    I suppose this could be done with a script running with appropriate intervals.

     

     

Please sign in to leave a comment.