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…


ReplTalk ReplTip Transactional Replication Performance Whitepaper

From: Taiyeb Zakir, Microsoft SQL Escalation Services If you’ve not seen this already, there is a good whitepaper on Transactional Replication Performance Tuning and Optimization. https://technet.microsoft.com/en-us/library/aa902656(v=sql.80).aspx . Yes, it is for SQL 2000 but most of the concepts are still applicable today all the way through to SQL Server 2014. –Chris Skorlinski


ReplTalk ReplTip – Replication Agent fails with “unable to start correctly”

ReplTalk ReplTip – Replication Agent fails with “unable to start correctly” Taiyeb Zakir Microsoft SQL Server Escalation Services When you have a large number of SQL Server Agent or Replication Agent Jobs running, some of the Jobs may not even start. You might see an error like this in the Event log: “The application was…


ReplTip – Bulk Updates with Transactional Replication

ReplTip – Bulk Updates with Transactional Replication by Taiyeb Zakir We’re seeing several customers performing bulk updates on the Publisher. Consider for example a table with 10 rows and 2 columns C1 and C2 and we run this update. Update table set C1 = “Something” This updated 10 rows as one set, but when Log…


ReplTip — Attunity CDC to replace Oracle Publishing

ReplTip — Attunity CDC to replace Oracle Publishing By Taiyeb Zakir Microsoft SQL Escalation Support   Starting with SQL 2012, Heterogeneous Replication to non-SQL Server Subscribers and Oracle Publishing is deprecated. To move data from Oracle to SQL, Attunity provides a feature called Change Data Capture for Oracle and it is shipped with SQL 2012…