如何最小化 SQL 复制中的数据 [英] How can I minimize the data in a SQL replication

问题描述

我想将数据从海上船只复制到陆上站点.连接有时是通过卫星链接进行的，可能会很慢且延迟很高.

I want to replicate data from a boat offshore to an onshore site. The connection is sometimes via a satellite link and can be slow and have a high latency.

我们应用程序的延迟很重要，岸上的人应该尽快拥有数据.

Latency in our application is important, the people on-shore should have the data as soon as possible.

有一个表被复制，由一个id、日期时间和一些长度可能不同的二进制数据组成，通常<;50 个字节.

There is one table being replicated, consisting of an id, datetime and some binary data that may vary in length, usually < 50 bytes.

离岸应用程序不断将数据(硬件测量)推送到表中，我们希望这些数据尽快在岸上传输.

An application off-shore pushes data (hardware measurements) into the table constantly and we want these data on-shore as fast as possible.

MS SQL Server 2008 中是否有任何技巧可以帮助减少带宽使用并减少延迟?初始测试使用 100 kB/s 的带宽.

我们的替代方案是滚动我们自己的数据传输，这里的初始原型使用 10 kB/s 的带宽(同时在相同的时间跨度内传输相同的数据).这没有任何可靠性和完整性检查，因此这个数字人为地很低.

Our alternative is to roll our own data transfer and initial prototyping here uses a bandwidth of 10 kB/s (while transferring the same data in the same timespan). This is without any reliability and integrity checks so this number is artificially low.

推荐答案

您可以尝试不同的复制配置文件或创建自己的配置文件.针对不同的网络/带宽场景优化了不同的配置文件.

You can try out different replication profiles or create your own. Different profiles are optimized for different network/bandwidth scenarios.

MSDN 在此处讨论复制配置文件.

MSDN talks about replication profiles here.

这篇关于如何最小化 SQL 复制中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！