SQL Server Performance Forum – Threads Archive

Deadlocks

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,
Ayub

use SQL Profiler to catch locksdeadlock event

Check BOL topic "Detecting and Ending Deadlocks" http://msdn2.microsoft.com/en-us/library/ms178104.aspx
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com 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,
Cali

Also you could take help of Blocked Process Thresholdhttp://msdn2.microsoft.com/en-us/library/ms181150.aspx] 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
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ 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.

]]>