Eric Lucht | Microsoft SQL Server Escalation Services Logging Options When the Merge subsystem is initialized, agent logging is automatically enabled using default values. The Agent will begin logging in the replmerg.log being created in the 100\COM (90\COM for SQL 2005) folder. This blog posting covers registry keys used to override the logging level of
Read More »
Amit Banerjee | Microsoft SQL Server Support TSQL Code: MS_MergeAgentStatistics.sql script located on SkyDrive MergePerformance or TechNet Code Share I have sometimes found the need to track the performance of the Merge Agents configured on the server without having to dig through the Replication Monitor or through the Merge Agent job history outputs. So, here
Read More »
Sateesh Yele | Microsoft SQL Server Support I would like to share information about an interesting Replication issue I recently worked. Customer was getting unusual error messages during synchronization. Symptom: Merge agent is failing with the following error message when validating large tables with checksum. The merge process was unable to perform data validation on
Read More »
Sateesh Yele | Microsoft SQL Server Support Peer-2-Peer Replication Wizard provides no options to enable table partition switching. There are 2 ways to enable this feature. 1) create the publication on ALL the peers using TSQL sp_addpublication 2) create the subscriptions using the user interface — or — 1) create the publication using the Replication
Read More »
Contributed by: Karol Korasadowicz Depending on type of data being replicated and network throughput adjusting the PacketSize parameter for the Distribution Agent may increase your overall Transactional Replication performance. -PacketSize packet_size Is the packet size, in bytes. The default is 4096 (bytes). http://msdn.microsoft.com/en-us/library/ms147328.aspx To see which setting has most impact, create test scenario which inserts/updates
Read More »