replication time just doubled (even with no table changes)
In the past week I've notice that the replication time (when not timing out) has increased significantly. Our set of SQL tables replicated in under 11 minutes last week. Currently, it's taking 20-25 minutes on a regular basis. Is there a reason this is happening (even when no new rows are being added to the table)? This is very difficult to troubleshoot since the code is hidden in the redgate DLLs. Could upgrading the libraries help (currently we're using version 6...not version 8)? I'm afraid to upgrade them now since it sounds like the SQL commandTimout in the redgate libraries has been decreased to 10 minutes.
0 · Share on Twitter