Post reply

SSISDB Catalog Defaults Best Practices

  • December 26, 2019 at 12:00 am

    #3710284

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

  • 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

     

  • 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.

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

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