Category: Troubleshooting

Troubleshooting ‘The process could not execute ‘sp_repldone/sp_replcounters’

Chris Skorlinski [MSFT] Troubleshooting November 8, 2015

Share this PostChris Skorlinski, SQL Server Escalation Services I worked on customer’s Transactional Replication issue today where LogReader was failing, restarting, then failing again. We used link below to enable logging to get a clearer picture of failure. http://blogs.msdn.com/b/repltalk/archive/2010/03/04/kb-article-312292-how-to-enable-replication-agents-for-logging-to-output-files-in-sql-server.aspx 16:02:45 OLE DB DISTOLE: sp_MSget_last_transaction 16:02:45 Publisher: {call sp_repldone ( 0x000a35e7000315e7005b, 0x000a35e7000315e7005b, 0, 0)} 16:32:45 Status:
Read More »

ReplTip – Breakout by Article

Chris Skorlinski [MSFT] Troubleshooting, Try This September 21, 2015

Share this PostMy 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 to move that bulk
Read More »

ReplTip – Setting LogScanThreshold can result in LogReader failure

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting September 21, 2015

Share this PostContent 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
Read More »

ReplTip – Troubleshooting sp_msmakegeneration

Chris Skorlinski [MSFT] Troubleshooting September 20, 2015

Share this Postby 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
Read More »

CDC may fail when assign a large size (more than 8000) value to the column

Chris Skorlinski [MSFT] Troubleshooting September 20, 2015

Share this Post–by Liwei Yin, Microsoft SQL China Support Assume you have CDC enabled for a table with text/ntext column. 1 You moidfy the colum type from text/ntext to varchar(max)/nvarchar(max) 2 Then you do an update to the column thereon, tried to assign a large size (more than 8000)value to the column, the CDC may
Read More »