Tips for using Snapshot Replication in SQL Server 2019 (Part 2) Consider locating both the publisher and the distributor on the same physical server. You can place the publisher and the distributor on the same physical server when the publisher server can perform the distribution tasks without any performance problems. By the way, using a separate SQL Server for the...
Tag: distribution agent
Tips for using Snapshot Replication in SQL Server 2019 (Part 1)
Tips for using Snapshot Replication in SQL Server 2019 (Part 1) Snapshot replication is a simplest type of replication. With this kind of replication, all replicated data (replica) will be copied from the Publisher database to Subscriber/Subscribers database on a periodic basis. Snapshot replication is best used as a method for replicating data that modified infrequently and when the size...
Tips for using Merge Replication in SQL Server 2017 (Part 2)
Tips for using Merge Replication in SQL Server 2017 (Part 2) If you do not need continuous replication, do not configure the Merge Agent to run continuously. Try to schedule the Merge Agent to run at regular intervals instead of running continuously. Try to schedule it during CPU idle time and slow production periods. By using it, you can decrease...
Tips for using Merge Replication in SQL Server 2017 (Part 1)
Tips for using Merge Replication in SQL Server 2017 (Part 1) Avoid using join filters with five or more tables. Because join filters with five or more tables can significantly degrade merge replication performance, you should avoid join filter for the small lookup tables, or denormalize the database design instead of using join filters with five or more tables. Use...
Tips for using Transactional Replication in SQL Server 2017 (Part 2)
Tips for using Transactional Replication in SQL Server 2017 (Part 2) Consider using transactional replication to memory-optimized tables. In SQL Server 2017, tables acting as transactional replication subscribers, excluding peer-to-peer transactional replication, can be configured as memory-optimized tables. To configure the subscriber database for supporting replication to memory-optimized tables, you should set the @memory_optimized property to true by using sp_addsubscription...
Tips for using Transactional Replication in SQL Server 2017 (Part 1)
Tips for using Transactional Replication in SQL Server 2017 (Part 1) 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. Increase the -MaxBcpThreads parameter of the Distribution Agent....
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 Snapshot Replication in SQL Server 2016
Some tips for using Snapshot Replication in SQL Server 2016 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. Do not configure the Distribution Agent to run continuously. […]
Troubleshooting SQL Server 2014 Snapshot Replication
Troubleshooting SQL Server 2014 Snapshot Replication If you have problems with SQL Server 2014 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 snapshot 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...