I have looked into articles to get the size of SSISDB down. One good way to do this was set the retention window for logging lower, currently down to 150 from the default of 365 days.

I would like to reduce this to 14 days but would like to be able to keep it at 150 days for packages that log an error.

I think I will have to dig into the SP that runs under the SSIS maint job. Before I do that I wanted to see if anyone has a better idea.

  • If you right click on the SSISDB and choose Reports, Standard Reports, Disk Usage by Top Tables, what do you see listed as the biggest offenders? – billinkc Jul 5 '16 at 14:48
  • And just to verify, you are taking backups, yeah? By default, the SSISDB is going to be in full recovery model so that database will keep growing until the transaction log gets backed up... – billinkc Jul 5 '16 at 14:49
  • internal event_message_context internal operation_messages internal event_messages – Joe Jul 5 '16 at 14:57
  • I am using full recovery model and backup nightly. Also run the SSIS maint job nightly. We just run a lot of executions and the entries build up fast. – Joe Jul 5 '16 at 14:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.