Halaman utama Jelajahi Bantuan
Masuk
RussellHankins
/
SQLServerDeadLocks
Liatin 1
Bintangi 0
Fork 0
Berkas Masalah 0 Tarik Permintaan 0 Wiki

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

Cabang: master
Ranting Tag
SQLServerDea...
ZIP TAR.GZ
unknown b3dce75f08 Initial upload 1 tahun lalu
README.md b3dce75f08 Initial upload 1 tahun lalu
pr_DeadlockList.txt b3dce75f08 Initial upload 1 tahun lalu
pr_Deadlock_Test.txt b3dce75f08 Initial upload 1 tahun lalu

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.