Accueil Explorer Aide
Connexion
RussellHankins
/
SQLServerDeadLocks
Suivre 1
Voter 0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki

A procedure to list recent deadlocks on sql server. Another procedure to cause a deadlock.

Branche: master
Branches Tags
SQLServerDea...
ZIP TAR.GZ
unknown b3dce75f08 Initial upload il y a 1 an
README.md b3dce75f08 Initial upload il y a 1 an
pr_DeadlockList.txt b3dce75f08 Initial upload il y a 1 an
pr_Deadlock_Test.txt b3dce75f08 Initial upload il y a 1 an

README.md

SQLServerDeadLocks

A procedure to list recent deadlocks on sql server. Another procedure to cause a deadlock.

  • pr_DeadlockList - Lists recent deadlocks. Lists which stored procedures/line numbers caused the error.
  • pr_Deadlock_Test - Causes a deadlock to happen.
    1. Open two query windows.
    2. Execute pr_Deadlock_Test in one of the query windows.
    3. Execute pr_Deadlock_Test in the other query window.
    4. Wait a minute or two. One of them should crash with a deadlock error.
    5. It creates two tables to make this happen, but those tables should be deleted once the test is over.
    6. You should then see a description of this deadlock if you run pr_DeadlockList.