SQL Server Performance Forum – Threads Archive

Dead-Lock findings

Hi, Is there any method to know if there is any deadlock? I have run some sps after my colleague changed them. They are still running. Any DBCC command?
Ashish Johri

---

1. You can capture DEADLOCK info using SQL PROFILER/TRACE….
2. You can enable Trace Flag 1222 check BOL topic "Detecting and Ending Deadlocks"…
MohammedU.
Moderator
SQL-Server-Performance.com

---

Hi
I would suggest to refer below links too
http://www.sql-server-performance.com/blocking.asp
http://www.sql-server-performance.com/reducing_locks.asp
http://support.microsoft.com/kb/298475
http://support.microsoft.com/kb/224453 Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com

---

Thanks MohammedU and Ghemant. Ashish Johri

---

Some more… http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/05/617960.aspx
http://www.sql-server-performance.com/art_deadlock_sql_2005.asp
MohammedU.
Moderator
SQL-Server-Performance.com

---

]]>