G
George Potemkin
Guest
> Correct. transaction state is only active or none. Transaction state change from begin to active is not replicated. But two-phase active to ready-to-commit changes should be. I guess the "none" state has a bit different meaning on target database. On souce database the transactions stay in the "none" state for a very short period of time. If duration is not short then something very wrong is happening in the database. On target database we will see the "none" state until a replication agent starts to process the notes from new transaction. Long period of this state is a feature rather than a problem on target database. PREPARING and PREPARED states should be short on source and target, should not them?
Continue reading...
Continue reading...