Deadlocks gone?

  • 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

  • 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?

  • Did you run a maintenance plan over the weekend that updated statistics or rebuilt indexes?


    And then again, I might be wrong ...
    David Webb

  • 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