Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Replication DB - Dead lock issue Expand / Collapse
Author
Message
Posted Monday, July 15, 2013 9:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:37 PM
Points: 312, Visits: 951
poratips (7/15/2013)
Thanks Alan.
Somehow we have every few minutes replication is running but sometimes it's locking and users have to wait and wait so sometimes we have to kill the session for user.


That does not sound like deadlocks, just good old-fashioned blocking.

If the third party is making extensive modifications during the first week of each month, you may have to work with them to resolve this issue.

Post #1473715
Posted Friday, August 9, 2013 9:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Thanks.
If i set up the Trace flag, and leave it to running for a month , will be ok or it will fill up the size?

Post #1482823
Posted Friday, August 9, 2013 12:19 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, November 20, 2014 3:37 PM
Points: 312, Visits: 951
Should not the be an issue unless you are generating hundreds of deadlocks.
Post #1482888
Posted Friday, August 9, 2013 1:34 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Thanks.
Post #1482917
Posted Saturday, August 10, 2013 8:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Thanks once again!
I am laready Monitoring Activity Monitor and but lots of job is mainly coming from Replicated DB.
Couple of job i have troubleshoot from other source job and improved performance adding right index and removed unnecessarry hint from the query.

Post #1483026
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse