Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Replication DB - Dead lock issue - Sql server 2005

Author  Topic 

poratips
Posting Yak Master

105 Posts

Posted - 2013-06-30 : 00:26:39
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,

poratips
Posting Yak Master

105 Posts

Posted - 2013-07-01 : 10:13:22
Any help, please?
Go to Top of Page

Hommer
Aged Yak Warrior

808 Posts

Posted - 2013-07-01 : 15:20:15
I think you have performance issue instead of replication issue.

Replication may add to the server load and throughput, but trying to fix dead lock from replication's prospective is a long shot.

quote:
Originally posted by poratips

Any help, please?

Go to Top of Page

poratips
Posting Yak Master

105 Posts

Posted - 2013-07-05 : 10:11:04
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.

Thanks.
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-07-09 : 10:41:18
You need to examine the queries/execution plans for the requests that are timing out.
Go to Top of Page

poratips
Posting Yak Master

105 Posts

Posted - 2013-07-10 : 08:11:40
Thanks Russell.
It's happening with many users and after that it's not that much waiting, any other needs to be observed?
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-07-10 : 11:58:45
You're running transactional replication and only synching monthly?

Why? And how long is the synchronization taking? You need to schedule it for off-peak hours if this is what you're doing.

Or synch much more often. Or use a different method of synching.
Go to Top of Page

poratips
Posting Yak Master

105 Posts

Posted - 2013-07-15 : 08:18:27
It's a Transactional Replication and running every few minutes as we are only subscriber.
Go to Top of Page
   

- Advertisement -