SSISDB Catalog Defaults Best Practices

• Steve Rezhener

  SSC Veteran

  Points: 229

  More actions

  December 26, 2019 at 12:00 am

  #3710284

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

• Matheus Azevedo

  SSC Rookie

  Points: 32

  More actions

  December 26, 2019 at 12:24 pm

  #3710474

  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: 5388

  More actions

  December 26, 2019 at 8:31 pm

  #3710603

  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.