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

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 Dead Lock Question.

Author  Topic 

Sonu619
Posting Yak Master

202 Posts

Posted - 2013-04-09 : 00:38:04
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

52326 Posts

Posted - 2013-04-09 : 04:26:16
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

42 Posts

Posted - 2013-04-09 : 04:27:00
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
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-04-10 : 01:47:29
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
   

- Advertisement -