Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Dead Lock Question.
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

202 Posts

Posted - 04/09/2013 :  00:38:04  Show Profile  Reply with Quote
Hi Guys,

I have two questions.

1) My first question, how i can find out on which table of my database has dead lock problem?

2) If i restart my server all dead lock problem solve mean go away or not? or still i have to kill each process manually?

Thank You.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 04/09/2013 :  04:26:16  Show Profile  Reply with Quote

SQL Server MVP
Go to Top of Page

Starting Member

42 Posts

Posted - 04/09/2013 :  04:27:00  Show Profile  Reply with Quote
1) A particular table cannot be said to be the cuase of a deadlock, its the order in which you read/write to tables within transactions by two users.
2) Restarting the service would solve the problem but its not the way to go. Rather figure out why the deadlocks occur and look for areas in your code that may cause the problem

Edited by - Lewie on 04/09/2013 04:27:41
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 04/10/2013 :  01:47:29  Show Profile  Visit jackv's Homepage  Reply with Quote
Various methods exist to locate and report on Deadlock details.

1)Profiler - Profiler Deadlock Graph Event

2)Trace Flags - 1204 and 1222

If Deadlocks are occurring – review the details of the deadlock. Analyse the SPIDs and the commands issued

Drill into the Transaction Logic.

Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000