Поделиться через


Свойство SnapshotGenerationAgent.MaxNetworkOptimization

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

Пространство имен:  Microsoft.SqlServer.Replication
Сборка:  Microsoft.SqlServer.Replication (в Microsoft.SqlServer.Replication.dll)

Синтаксис

'Декларация
Public Property MaxNetworkOptimization As Boolean 
    Get 
    Set
'Применение
Dim instance As SnapshotGenerationAgent 
Dim value As Boolean 

value = instance.MaxNetworkOptimization

instance.MaxNetworkOptimization = value
public bool MaxNetworkOptimization { get; set; }
public:
virtual property bool MaxNetworkOptimization {
    bool get () sealed;
    void set (bool value) sealed;
}
abstract MaxNetworkOptimization : bool with get, set 
override MaxNetworkOptimization : bool with get, set
final function get MaxNetworkOptimization () : boolean 
final function set MaxNetworkOptimization (value : boolean)

Значение свойства

Тип: System.Boolean
A Boolean value.

Реализует

ISnapshotGenerationAgent.MaxNetworkOptimization

Замечания

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.

См. также

Справочник

SnapshotGenerationAgent Класс

Пространство имен Microsoft.SqlServer.Replication