Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: deadlock detected ,Internal rollbacks due to deadlock

    I noticed in my db snapshot,

    deadlock detected =44
    Internal rollbacks due to deadlock=69.

    Could anyone explain why there is an increase in no.of Internal rollbacks due to deadlock than the actual deadlock detected.


  2. #2
    Join Date
    Oct 2003
    In a deadlock, eventually one party is chosen to be the loser. If the losing transaction contained multiple inserts/updates, they will all be rolled back.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts