Tips for using Merge Replication in SQL Server 2019 (Part 2) Run the Snapshot Agent as infrequently as possible. The Snapshot Agent bulk copies data from the Publisher to the Distributor, which results in some performance degradation. So, try to schedule it during CPU idle time and slow production periods. Specify the -Validate parameter of the Merge Agent. This parameter...
Tag: merge agent
Tips for using Merge Replication in SQL Server 2019 (Part 1)
Tips for using Merge Replication in SQL Server 2019 (Part 1) Consider setting the -MaxNetworkOptimization parameter of the Snapshot Agent to 1 to avoid sending irrelevant deletes to the Subscriber. Irrelevant deletes are DELETE commands that are sent to Subscribers for rows that do not belong to the Subscriber’s partition. The default value of the -MaxNetworkOptimization is 0. Setting -MaxNetworkOptimization...
Troubleshooting SQL Server 2016 Merge Replication
Troubleshooting SQL Server 2016 Merge Replication If you have problems with SQL Server 2016 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 Merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Troubleshooting SQL Server 2016 Transactional Replication
Troubleshooting SQL Server 2016 Transactional Replication If you have problems with SQL Server 2016 transactional replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 Transactional replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Some tips for using Merge Replication in SQL Server 2016 (Part 2)
Some tips for using Merge Replication in SQL Server 2016 (Part 2) Avoid publishing unnecessary data. Try to restrict the amount of published data. This can results in good performance benefits, because SQL Server will publish only the amount of data required. This can reduce network traffic and boost the overall replication performance. Set the “Maximize Throughput for Network Applications” […]
Some tips for using Merge Replication in SQL Server 2016 (Part 1)
Some tips for using Merge Replication in SQL Server 2016 (Part 1) Avoid replicating text, ntext and image columns. These data types require more storage space and processing than other column data types. Consider setting the -OutputVerboseLevel parameter of the Merge Agent to 0. This parameter specifies whether the output should be verbose. There are three available values: 0 – […]
Troubleshooting SQL Server 2014 Merge Replication
Troubleshooting SQL Server 2014 Merge Replication If you have problems with SQL Server 2014 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 Merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]
SQL Server 2014 Replication – Part 2
SQL Server 2014 Replication – Part 2 Author: Basit A. Farooq Editor’s note: In this second part of my SQL Server 2014 Replication article series, you’ll first learn about different types of replication agents and there security context. Next, you’ll learn how configure Distributor. Finally, you’ll learn how to configure Snapshot replication. Replication agents Replication agents perform the activities necessary...