Category: Troubleshooting

Distribution Agent fails with “Could not remove directory” error

ReplTalk Troubleshooting January 2, 2011

Share this PostSateesh Yele Microsoft SQL Server Support Symptom: The Distribution Clean up job fails with the following error. Executed as user: Domainname\Username. Could not remove directory ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\ReplData\unc’. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE 42000] (Error 20015). The step failed. Consider
Read More »

Lock Timeout in Replication Create Publication

Chris Skorlinski [MSFT] Troubleshooting December 5, 2010

Share this PostNormally, the Snapshot create publication script only needs to lock the table long enough to generate a Create Table script for the Distribution Agent to apply to the Subscriber. However, the create Publication was being blocked on the Publisher. We discovered a database trigger used to AUDIT all schema modification on the Publisher
Read More »

Unexplained Latency in the Distribution Agent using Named Pipe

Chris Skorlinski [MSFT] Troubleshooting November 23, 2010

Share this PostJust wanted to give a heads up about a SQL Replication Distribution Agent Latency problem we observed today. The Distribution Agent to 1 subscriber was only delivering about 500 cmds/sec while other subscribers were getting 4000 cmds/sec. We noticed the Distribution Agent was running under a different PacketSize, made that change, no noticeable
Read More »

Unexplained slowness in SQL 2008 on Windows 2008 R2

Chris Skorlinski [MSFT] Troubleshooting October 26, 2010

Share this PostA customer called today about an unexplained slowness in SQL Server 2008 on Windows 2008 R2. All SQL data looked great, no blocking, no obvious IO bottlenecks, just overall slow performance. 976700 An application stops responding, experiences low performance, or experiences high privileged CPU usage if many large I/O operations are performed in
Read More »

Troubleshooting LogReader Timeout executing sp_replcmds

ReplTalk Troubleshooting October 25, 2010

Share this PostUpdated post on The process could not execute ‘sp_replcmds’ Share this Post