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 Expand / Collapse
Author
Message
Posted Monday, May 19, 2008 9:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Monday, May 19, 2008 10:04 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:32 AM
Points: 2,678, Visits: 2,394
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
Posted Monday, May 19, 2008 10:08 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 10:30 PM
Points: 1,688, Visits: 8,759
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 »

Add to briefcase

Permissions Expand / Collapse