View Revisions: Issue #5018
| Summary | 0005018: MS log miner needs snapshot isolation to work under heavy load | ||
|---|---|---|---|
| Revision | 2021-06-08 16:56 by elong | ||
| Description | The Log Miner for Microsoft SQL-Server database needs to use snapshot isolation to avoid concurrency issues that result in missing changes. The changetable may not reflect all changes for the current change number returned by change_tracking_current_version() with other isolation levels. Setting needed in engine file: target.db.jdbc.isolation.level=4096 SQL needed to run on database: ALTER DATABASE AdventureWorksLT SET ALLOW_SNAPSHOT_ISOLATION ON; |
||
| Revision | 2021-06-08 16:54 by elong | ||
| Description | The Log Miner for Microsoft SQL-Server database needs to use snapshot isolation to avoid concurrency issues that result in missing changes. The changetable may not reflect all changes for the current change number returned by change_tracking_current_version() with other isolation levels. | ||