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...
Tag: subscriber
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....
Tips for using Snapshot Replication in SQL Server 2017
Tips for using Snapshot Replication in SQL Server 2017 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. Consider specifying a simple or bulk-logged recovery model for the subscription database....
Troubleshooting SQL Server 2016 Snapshot Replication
Troubleshooting SQL Server 2016 Snapshot Replication If you have problems with SQL Server 2016 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 snapshot 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 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 – […]
Some tips for using Transactional Replication in SQL Server 2016 (Part 2)
Some tips for using Transactional Replication in SQL Server 2016 (Part 2) Set the “Maximize Throughput for Network Applications” option. This can increase SQL Server performance, because Windows will allocate more RAM to SQL Server than to its file cache. Consider locating both the publisher and the distributor on the same physical server. You can place the publisher and the […]
Some tips for using Transactional Replication in SQL Server 2016 (Part 1)
Some tips for using Transactional Replication in SQL Server 2016 (Part 1) Try to keep transactions as short as possible. Because SQL Server send changes from the Publisher to Subscriber as INSERT, UPDATE, and DELETE statements you should keep transactions as short as possible to help the Distribution Agent to transfer transactions through the network. By the way, keeping transactions […]