Home Forums SQL Server 2008 SQL Server 2008 - General Replication DB - Dead lock issue RE: Replication DB - Dead lock issue

  • July 10, 2013 at 8:19 am

    #1631251

    The best way to resolve deadlocks is adding the trace flag as Wolfgang mentioned. That said, when you are dealing with Replication I strongly suggest you become familiar with the Replication Monitor. Especially when dealing with Transactional Replication (I think that's what you meant by "Transactional Snaphot") and Merge Replication. I could not live without it.

    Sebastian Meine's Stairway to Replication[/url] is an excellent read. Take a look at Stairway to SQL Server Replication - Level 10: Troubleshooting[/url] for more details about the Replication Monitor.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001