June 21, 2016 at 2:36 pm
I've CDC running on SQL server 2008 R2 server. I implemented the same CDC on SQL server 2014 server since we are migrating to a new server. When I query the cdc table on 2008 R2, I don't see Start_LSN appearing more than 2,
but in 2014, its appearing more than 3000 in some cases.
Any idea what should I check to put hem in synch as this is brining in tens of thousands of more records than I actually need.
SELECT [__$start_lsn], COUNT(*) FROM cdc.dbo_TABLE_CT
group BY [__$start_lsn]
HAVING COUNT(*) > 1
June 21, 2016 at 6:51 pm
In other words, I'm getting same start_lsn number for so many transactions, which doesn't sound accurate. Is there some settings that I need to look at?
June 24, 2016 at 8:02 pm
Any help would be much appreciated. It seems like in 2014 its tracking lots of changes than in 2008 R2 even though base table is changed quite a few times.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply