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.
| 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? |
 |
|
|
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?
|
|
|
|
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. |
|
|
|
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. |
|
|
|
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? |
|
|
|
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. |
|
|
|
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. |
|
|
|
|
|
|
Replication DB - Dead lock issue - Sql server 2005