SSISDB Catalog Defaults Best Practices

  • Steve Rezhener

    SSC Veteran

    Points: 263

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

  • Matheus Azevedo

    SSC Rookie

    Points: 32

    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. https://www.sqlservercentral.com/blogs/a-better-way-to-clean-up-the-ssis-catalog-database-1

    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

     

  • Misha_SQL

    SSCertifiable

    Points: 5397

    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 3 (of 3 total)

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