O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring Transactional Replication

In the previous section of the chapter, we learned how to install Transactional Replication using wizard and using T-SQL. In this section, we will learn how to configure Transactional Replication using T-SQL and/or wizard so that we can have performance benefit.

Parameters to be configured with Distribution Agent profile

There are some parameters that can be customized according to the requirement and can help increase the performance of the replication. These parameters include:

  • Large Object (LOB) data types: Transactional Replication supports LOB to get published. Whenever there is a change recorded in the LOB, it actually updates only fragments of the changed data and not the whole data. We should set the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required