Deadlocks | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


I have my database running on SQL 2005. I was wondering, how could i capture deadlocks happening on my system? Is there a way i could do this? I know, i could setup a alert to capture them. But i am more intrested to see in a period of time, how many deadlocks happened and what were they doing? Is there a way to capture this info? appreciated if somebody share this. Thanks,
use SQL Profiler to catch locksdeadlock event
Check BOL topic "Detecting and Ending Deadlocks"
Microsoft SQL Server MVP
Moderator All postings are provided “AS IS” with no warranties for accuracy.

MohammedU, thanks for providing the link. It explains in detail and was very helpful. Thanks again,
Also you could take help of Blocked Process Threshold] in SQL Server 2005 version, this option is useful to manually detect the long-term deadlock is to configure the blocked process threshold. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.