We currently have in place CDC, DW team is reading data, everyone happy. Then we needed to add couple new columns. Easy peasy following this answer... well, actually we had some hiccups but that's solved. But that was on a small environment just to check that the steps to follow are ok. Now is time to deploy that on a way bigger environment. So, question:
Is there a way to monitor CDC while the 2nd capture instance is running populating data in parallel with the old capture instance? Extended events maybe? Any recommendation on what to look? IO, log growth, storage, memory grants maybe?