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.
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
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).aspx2) 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 |
|
|
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 Event2)Trace Flags - 1204 and 1222If Deadlocks are occurring – review the details of the deadlock. Analyse the SPIDs and the commands issuedDrill into the Transaction Logic. Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|