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

Deadlocks gone? Expand / Collapse
Author
Message
Posted Thursday, January 17, 2013 3:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 3:55 PM
Points: 3, Visits: 83
We have a situation where we had an application that was receiving thousands of deadlocks up until last Monday. They suddenly mitigated. There were no changes to the application server nor the database server and the number of users have not been reduced. Any thoughts on why this happened?

Regards,

David
Post #1408637
Posted Thursday, January 17, 2013 3:40 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:39 PM
Points: 3,122, Visits: 11,405
Were there any changes to application code or stored procedures?

Is it possible that the database was altered to set read_committed_snapshot on?

Is is possible that the users just stopped using the part of the application that was causing the deadlocks?

Post #1408646
Posted Thursday, January 17, 2013 3:49 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:54 PM
Points: 897, Visits: 7,094
Did you run a maintenance plan over the weekend that updated statistics or rebuilt indexes?



And then again, I might be wrong ...
David Webb
Post #1408652
Posted Thursday, January 17, 2013 4:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 3:55 PM
Points: 3, Visits: 83
Yes, we did. However, we think the cause was table fragmentation.

Thanks!
Post #1408657
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse