deadlock

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » deadlock

deadlock

Rate Topic

Display Mode

Topic Options

Author

Message

sandhyarao49

Posted Monday, May 19, 2008 9:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 18, 2013 9:50 PM
Points: 119, Visits: 650

I have a small doubt.
Each and every error in sqlserver is logged in sql server error log.
So if a dead lock occurs the errors should be logged in to the error log.
Then for troubleshooting deadlocks we have to enable traceflags 1204 and 1222.
Why we have to enable these trace flags . Is there any peculiar advantage with these trace flags. if we not enable these flags whether deadlock information will be logged in to the error log or not.

Post #502926

kevriley

Posted Monday, May 19, 2008 10:04 AM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:01 PM
Points: 2,677, Visits: 2,273

traceflags 1204 and 1222 return more detailed information about the processes involved :

http://msdn.microsoft.com/en-us/library/ms178104.aspx

gives a full description

Post #502932

MANU-J.

Posted Monday, May 19, 2008 10:08 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 11:42 AM
Points: 1,654, Visits: 8,563

Go thru this too if you are intrested in resolving deadloacks issue:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Post #502934

« Prev Topic | Next Topic »

Permissions