SnapshotGenerationAgent.MaxNetworkOptimization Property

  • 發行項

Gets or sets whether out-of-partition deletes are sent to the Subscriber.

命名空間: Microsoft.SqlServer.Replication
組件: Microsoft.SqlServer.Replication (in microsoft.sqlserver.replication.dll)

語法

'宣告
Public Property MaxNetworkOptimization As Boolean

public bool MaxNetworkOptimization { get; set; }

public:
virtual property bool MaxNetworkOptimization {
    bool get () sealed;
    void set (bool value) sealed;
}

/** @property */
public final boolean get_MaxNetworkOptimization ()

/** @property */
public final void set_MaxNetworkOptimization (boolean value)

public final function get MaxNetworkOptimization () : boolean

public final function set MaxNetworkOptimization (value : boolean)

屬性值

A Boolean value.

備註

Out-of-partition deletes refer to deletes that do not belong to the subscription to a merge publication defined by a parameterized row filter. Replicating these deletes does not affect data integrity or convergence, but they can result in unnecessary network traffic.

The default value of MaxNetworkOptimization is false.

Setting MaxNetworkOptimization to true minimizes the chances of replicating irrelevant deletes, thereby reducing network traffic and maximizing network optimization. Setting MaxNetworkOptimization to true can also increase the storage of metadata and cause performance to degrade at the Publisher if multiple levels of join filters and complex subset filters are present. You should carefully assess your replication topology and enable this optimization only if network traffic from irrelevant deletes is unacceptably high.

執行緒安全性

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

開發平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

目標平台

如需受支援的平台清單，請參閱＜安裝 SQL Server 2005 的硬體和軟體需求＞。

請參閱

參考

SnapshotGenerationAgent Class
SnapshotGenerationAgent Members
Microsoft.SqlServer.Replication Namespace