sp_config_rep_agent

The sp_config_rep_agent system procedure has been updated to support the additional distribution model filter for the multipath distribution model property.

Select the filter distribution model to distribute data from the primary database through the available replication paths to achieve parallel replication and improved replication performance. Enable multiple scanners if you intend to set the distribution model to filter.

To set the distribution model:

sp_config_rep_agent database, ‘multipath distribution model’, {‘connection' | 'object' | 'filter'} 

For information about setting the distribution model and configuring the distribution by column filter, see Additional Distribution Mode for Multi-Path Replication in the Replication Server New Features Guide.

Related concepts
Adaptive Server Support for Replication by Column Value
sp_replication_path
Changed Monitoring Tables
Related reference
monRepSchemaCache