May 19, 2008 at 9:52 am
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.
May 19, 2008 at 10:04 am
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
May 19, 2008 at 10:08 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply