Startsida Utforska Hjälp
Logga in
RussellHankins
/
SQLServerDeadLocks
Bevaka 1
Stjärnmärk 0
Fork 0
Filer Ärenden 0 Pull-förfrågningar 0 Wiki

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

Gren: master
Grenar Taggar
SQLServerDea...
ZIP TAR.GZ
unknown b3dce75f08 Initial upload 1 år sedan
README.md b3dce75f08 Initial upload 1 år sedan
pr_DeadlockList.txt b3dce75f08 Initial upload 1 år sedan
pr_Deadlock_Test.txt b3dce75f08 Initial upload 1 år sedan

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.