Post reply

CDC table returning more rows for the same start_lsn

  • June 21, 2016 at 2:36 pm

    #314512

    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

    #1886136

    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

    #1886874

    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