Hi, We have One Database which is a Replication Db, sometimes during beginning of the month, lot of user activities going and we having Dead lock issue. Any one has idea how to prevent the dead lock in Replication DB? We have to manually kill the user session one by one but if someone having same kind of issue and have any idea?
Thanks Hommer. Actually what happening as when during begining of the month replication DB runs and updaing/Inserting into lots of tables and that activities are heavy and during that time our other activities also running so user process hot hung or they have to wait for longer period of time and all the processes becomeing too slow.. We have Transaction Replication DB and we are subscriber and publisher is 3rd party. Looking into more depth, it's not showing as a blocking or Deadlock but user processes are waiting for longer period and it's too much for other process. Appreciate your inputs.