Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deadlock - SQL Server 2000 Expand / Collapse
Author
Message
Posted Thursday, December 20, 2007 7:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 1, 2010 12:29 AM
Points: 1, Visits: 7
Hi,

In our production server, the deadlock happening frequently. Is anyone can help on how to troubleshoot and identify the deadlock and how to solve it? Thanks.

Post #435460
Posted Thursday, December 20, 2007 11:28 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 40,258, Visits: 36,681
Enable traceflag 1204. That will write the deadlock graphs into the SQL error log. With the info in the graph, you should be able to locate the cause of the deadlock and rectify the code.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #435483
Posted Friday, February 15, 2008 10:52 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 25, 2010 6:09 AM
Points: 1,621, Visits: 409
Hi,

Check out the below link on how to resolve Dead-lock things.
http://www.code-magazine.com/Article.aspx?quickid=0309101

Thanks -- Vj
http://dotnetvj.blogspot.com


Thanks -- Vijaya Kadiyala
www.dotnetvj.com
SQL Server Articles For Beginers



Post #456424
Posted Thursday, February 28, 2008 10:51 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, December 30, 2013 2:07 AM
Points: 1,438, Visits: 414
yes gailshaw is correct ,but i like to add that before rectifying your code just understand one thing that there are two kinds of deadlock ,namely cycle deadlock and conversion deadlock be careful while dealing with conversion deadlock because it is not easy to
Post #462177
Posted Thursday, February 28, 2008 11:31 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 8:08 AM
Points: 2,365, Visits: 1,846
Hi

You can also use the activity monitor under management in SSMS. Here you can add filters including "blocking "filters to see the processes that are causing the blocking in your database.



"Keep Trying"
Post #462181
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse