Tag: replication

Pro Members SQL Server Standard Members

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....

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

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...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

Tips for using Very Large Databases in SQL Server 2016

Tips for using Very Large Databases in SQL Server 2016 Try to create as many database files, as there are physical disk arrays so that you have one file per disk array. This will improve performance, because when a table is accessed sequentially, a separate thread is created for each file on each disk array in order to read the...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
SQL Server

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” […]

SQL Server

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 – […]

SQL Server

Troubleshooting SQL Server 2014 Transactional Replication

Troubleshooting SQL Server 2014 Transactional Replication If you have problems with SQL Server 2014 transactional replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 Transactional replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]

SQL Server

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 […]

Pro Members SQL Server Standard Members

SQL Server 2014 Snapshot Replication Optimization Tips

SQL Server 2014 Snapshot Replication Optimization Tips Do not configure the Distribution Agent to run continuously. Try to schedule the Distribution Agent to run at regular intervals instead of running continuously. By using it, you can decrease the total SQL Server overhead. Consider placing snapshot folder on a disk that is not used to store database or log files. Placing...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register
Pro Members SQL Server Standard Members

SQL Server 2014 Replication – Part 1

SQL Server 2014 Replication – Part 1 Author: Basit A. Farooq; You use replication to move data between servers. Replication is important in distributed environments, when archiving data, and as an inexpensive way to support high availability. In this topic, you will learn about the different types of replication, the components involved in replication, and the steps necessary to configure...

This content is for Pro, Pro Member, Pro Member Annual - Valentine's, Pro Member Monthly - Valentine's, Standard, Standard Member, Standard Member Annual - Valentine's and Standard Member Monthly - Valentine's members only.
Log In Register