You administer several Microsoft SQL Server 2012 database servers.
Merge replication has been configured for an application that is distributed across offices throughouta wide
area network (WAN).
Many of the tables involved in replication use the XML and varchar(max) data types. Occasionally, merge
replication fails due to timeout errors.
You need to reduce the occurrence of these timeout errors. What should you do?
A.
Set the Merge agent on the problem subscribers touse the slow link agent profile.
B.
Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
C.
Change the Merge agent on the problem subscribersto run continuously.
D.
Set the Remote Connection Timeout on the Publisher to 0.
Explanation:
When replication is configured, a set of agent profiles is installed on the Distributor. An
agent profile contains a set of parameters that areused each time an agent runs: each
agent logs in to the Distributor during its startupprocess and queries for the parameters in
its profile. For merge subscriptions that use Web synchronization, profiles are downloaded
and stored at the Subscriber. If the profile is changed, the profile at the Subscriber is
updated the next time the Merge Agent runs. For more information about Web
synchronization, see Web Synchronization for Merge Replication.
Replication provides a default profile for each agent and additional predefined profiles for
the Log Reader Agent, Distribution Agent, and MergeAgent. In addition to the profiles
provided, you can create profiles suited to your application requirements. An agent profile
allows you to change key parameters easily for all agents associated with that profile. For
example, if you have 20 Snapshot Agents and need tochange the query timeout value (the
-QueryTimeoutparameter), you can update the profile used by theSnapshot Agents and
all agents of that type will begin using the new value automatically the next time they run.
You might also have different profiles for different instances of an agent. For example, a
Merge Agent that connects to the Publisher and Distributor over a dialup connection could
use a set of parameters that are better suited to the slower communications link by using
the slow linkprofile.