replication using 2008r2

• gurudutt.dhareshwar

  Newbie

  Points: 3

  More actions

  November 15, 2011 at 5:02 pm

  #246240

  Hi ,

  I am facing with a strange problem while using replication in sql server 2008 r2 it seems there are a lot of deadlocks been observed and the system really slows down a lot. using transactional replication. is there a way to resolve this.

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  November 15, 2011 at 10:20 pm

  #1408254

  Are you sure replication is causing deadlocks?

  In which server are you having deadlocks, publisher or subscriber?

  Are the replicated tables involved in deadlocks?

  Do you delete/update the rows from replicated tables in subscriber?

  Which isolation level do you use?

  May be if you post the deadlock-graph, others can analyze and give you better solution.