Deadlock - SQL Server 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Strategies » Deadlock - SQL Server 2000

Deadlock - SQL Server 2000

Rate Topic

Display Mode

Topic Options

Author

Message

geetha-316940

Posted Thursday, December 20, 2007 7:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 01, 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

GilaMonster

Posted Thursday, December 20, 2007 11:28 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 6:25 AM
Points: 37,679, Visits: 29,934

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

Vijaya Kadiyala

Posted Friday, February 15, 2008 10:52 AM

SSCommitted

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

sam_mastermind

Posted Thursday, February 28, 2008 10:51 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 06, 2013 12:24 AM
Points: 1,261, Visits: 403

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

ChiragNS

Posted Thursday, February 28, 2008 11:31 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

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 »

Permissions