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
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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