Author: Chris Skorlinski [MSFT]

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
Read More »

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
Read More »