Data Replication 1


Type: Posts; User: sjt003; Keyword(s):

Search: Search took 0.00 seconds.

  1. Can I have multiple version of the CDC Designer on the same server?


    I currently have 2 instances of SQL Server on my server - 2016 and 2017. CDC designer is running on the 2016 instance. I want to move it to the 2017 instance and eliminate 2016. My thought...
  2. Get net changes occasionally does not capture some rows - why is nolock used?

    I have a problem that every few weeks, the get_net_changes function does not pick up some change data capture rows that are within the lsn range. Then I have variances from the source system and...
  3. Bad execution plan / statistics

    It looks like it was a statistics problem. I would have a lot of rows in the change table, then several thousand would come in suddenly with new lsn's. But it wasn't enough to trigger new...
  4. fn_cdc_get_net_changes exponentially slow with high volume


    I'm having a problem that one of the tables I capture via fn_cdc_get_net_changes is occasionally extremely slow when the volume is high. I understand that higher volume will lead to slower...
Results 1 to 4 of 4