February 20, 2014 at 7:00 am
We've had a problem with our (already optimised) daily clean-up task recently. While troubleshooting, we noticed that part of the standard clean-up task is the removal of certificates and symmetric keys (check out the SSISDB.internal.cleanup_server_retention_window proc for details).
Does anyone know what this is all about? When are these certs created, and why?
--edit: fixed typo
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 28, 2014 at 5:57 pm
Has anyone found a solution to this yet? I am having the same problem with this maintenance task. I have over 600,000 rows in the symmetric and certification sys tables. I would like to slim down the tables to something manageable.
June 12, 2018 at 11:27 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply