change-data-capture Archives

Which parameters and metrics to look at when CDC based replication is causing high load?

By adminPosted on September 29, 2022

Question : I’m investigating the reasons why a Tungsten Replicator extractor is causing heavy load on an Oracle 11g database. […]

By adminPosted on August 18, 2022

Question : I have a few tables on which I have enabled CDC. As each row in CDC table contains […]

By adminPosted on July 5, 2022

Question : Does anybody know if change data capture functions return always data in the order of occurence?. In a […]

By adminPosted on May 5, 2022

Question : Change Data Capture looks to be exactly what I need… Except. All of my database actions come from […]

By adminPosted on April 4, 2022

Question : I am trying to create an SP on a CDC enabled database. SP contain an update statement for […]

By adminPosted on April 1, 2022

Question : I am having a problem running the CDC change capture job against some of my test databases. The […]

By adminPosted on March 31, 2022

Question : I’m trying to enable Change Data Capture on a table with a clustered columnstore index, a unique non-clustered […]

By adminPosted on March 15, 2022

Question : We currently have in place CDC, DW team is reading data, everyone happy. Then we needed to add […]

By adminPosted on March 12, 2022

Question : I’m implementing ingestion job from SQL Server 2016. For performance reasons we want to implement incremental loads. Few […]

By adminPosted on March 11, 2022

Question : I am trying to locate fastest way to find difference between two tables. The first table is populated […]