SSISDB Catalog Defaults Best Practices

  • Comments posted to this topic are about the item SSISDB Catalog Defaults Best Practices

  • Nice tips. It is definitely worth taking into consideration the retantion periods of your packages executions.

    I also would like to mention the Tim Mitchell recomendations for cleaning up SSISDB more efficiently.

    I use a combination of the configurations exposed in this article and in some really huge enverioments, with thousands of packages being executed every week, I had to customize my own SQL Server Agent Jobs based on the scripts provided by Tim and completely disabled the SSIS Maintenance Job


  • We also ran into issues with SSISDB clean-up job once we had a large number of packages and executions. The built-in mechanism didn't work no matter how much we played with configuration values, but already mentioned Tim Mitchell's approach does the job very well.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply