If you are running replications in mirroring or sychronization modes, the transaction log on the table from which you are replicating is checked regularly to see if any transactions have occurred. You can modify the interval between log checks to adjust for best performance in your environment. For example, if you are using the default setting of 60 seconds, the source database log will be checked every 60 seconds for new transactions. To keep your source and target tables synchronized as closely as possible, you might change the frequency to every 15 seconds. However, if the number of transactions between checks is very high, setting the frequency to 15 seconds will not help because updates to the target database could take longer than 15 seconds.
To change the frequency of log checks:
In the Management Center Metadata Explorer, select the replication.
Using the right mouse button menu, make sure that there is no check mark next to Enable Replication.
If Enable Replication is checked, select it to remove the checkmark. You have now disabled the replication.From the right mouse button menu, choose Replication Properties.
In the Replication Properties dialog, go to the Preferences tab.
Change the value of the Read Interval field. The default value is 60 seconds.
Click OK to close the Replication Properties dialog.
From the right mouse button menu, select Enable Replication.
You should see a check mark next to the menu item to show that it is enabled.
If the replication is already running, for this change to take effect, you will need to disable, then re-enable the replication
Related Topics