I have database which is 1.6 TB and enabled CDC on it with retention of 8 days. Over the week end we received huge delta volume in the form of Updates in base tables. So, out CDC is running 36 hours behind the real time.
How would i figure out what is the appropriate retention period for CDC on that Database.
Is there any thumb rule?