sql-server - SQL Server - merge replication - 15 seconds delay between publisher and a subscriber

问题描述

We have a client with a very small database (30 MB), the client has a merge replication between 2 physically connected stations with 10 GB communication cable. The SQL version is SQL Server standard edition 2014.

Let say table A is empty, when we make a table insert in the subscriber or the publisher, The synchronization time (inserting the data into the other side of the replication) is 15 seconds.

2 questions:

Is 15 seconds a reasonable time? Is it possible to reach a level of synchronize time of a second?

Thanks

标签： sql-serverdatabase-replication

sql-server - SQL Server - merge replication - 15 seconds delay between publisher and a subscriber

问题描述

解决方案

推荐阅读