SQL Server Performance Forum – Threads Archive

How to resolve deadlock issues

Have a look into this. http://support.microsoft.com/kb/832524/
http://www.sql-server-performance.com/deadlocks.asp

Is there something missing or this really only the question in the subject? —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de

Ajay, if you face a deadlock problem, just describe us the problem.
Thanks,
Ram "It is easy to write code for a spec and walk in water, provided, both are freezed…"

Hi, By using sysprocesses table in the master database, you can trace which spid is causing the deadlock. You can also use : DBCC TRACEON (1204).
Regards,
N.Babu Godson Samuel Don’t try to do different things; Do things differently.

Adding to babusamuel’s reply Just run DBCC INPUTBUFFER(SPID)to know the last command that is run..

Ajay
A short question to get a wide reply, I don’t think so…it shows your negligence to get such an open answer, as suggested be specific about your problem with an explanation. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

]]>