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

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

Sonu619
Posting Yak Master

195 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.

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 04/09/2013 :  04:26:16  Show Profile  Reply with Quote
http://msdn.microsoft.com/en-in/library/ms178104(v=sql.105).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Lewie
Starting Member

Australia
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.
http://msdn.microsoft.com/en-au/library/ms178104(v=sql.105).aspx
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

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2043 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
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.05 seconds. Powered By: Snitz Forums 2000