Merge metadata cleanup changes in SQL Server 2012 SP2 and SQL Server 2014 SP1

  Content provided by: Hugo Nunes, Microsoft Support Escalation Engineer TITLE: Merge metadata cleanup changes in SQL Server 2012 SP2 and SQL Server 2014 SP1 Abstract: This article briefly describes the change in the merge metadata cleanup logic introduced in SQL Server 2012 SP2 and SQL Server 2014 SP1, and provides some recommendations Terms and…


ReplTip – Breakout by Article

–Chris Skorlinski, Microsoft SQL Escalation Services My friend Brendan Odwyer gave me great query to show Distribution database breakout by article for Transactional Replication publications.  We used this to identify 1 table that had +90 million rows  pending in the Distribution database as result of a large bulk update.  It would have taken Replication days…


ReplTip – Setting LogScanThreshold can result in LogReader failure

Content provided by Sateesh Yele, Microsoft SQL Escalation Services BOL/MSDN documents –Logscanthreshold as “internal use only”. https://technet.microsoft.com/en-us/library/ms146878(v=sql.110).aspx -LogScanThreshold scan_threshold Internal use only. Other blog postings imply how to adjust this setting for better Logreader agent performance.  If you add this parameter to the Logreader SQL Agent command line and start the agent, Logreader agent will…


Primary Key design considerations for Merge Replication

by Holger Linke, Microsoft SQL Escalation Engineer GUIDs and Clustered Indexes Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones.  With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical.  As you know, each row is…


ReplTip – Troubleshooting sp_msmakegeneration

by Holger Linke, Microsoft SQL Escalation Engineer Symptoms: The merge agent may get stuck without apparent progress, or even fail with a timeout error. If several merge agents are trying to synchronize at the same time, they would block each other, until the agent which is running sp_msmakegeneration finishes the call. If the execution of…