January 17, 2013 at 3:14 pm
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
January 17, 2013 at 3:40 pm
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?
January 17, 2013 at 3:49 pm
Did you run a maintenance plan over the weekend that updated statistics or rebuilt indexes?
January 17, 2013 at 4:08 pm
Yes, we did. However, we think the cause was table fragmentation.
Thanks!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply