Kindly Clarify: How to capture the DeadLock information/error from SQL Server ?

Posted by Jasminej under Sql Server on 5/3/2012 | Points: 10 | Views : 1201 | Status : [Member] | Replies : 1
How to capture the DeadLock information/error from SQL Server ?

But, I don't want to Restart the Server.




Responses

Posted by: Pandians on: 5/3/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
You can simple enable the following Trace..

1222
1204
1205

So, You don't need to Restart the Server!

Use Master
Go
DBCC TraceOn (1222,1204,1025,-1)
Go

- so, we have enabled the Traces to capture the DeadLock related Error on "SQL Server Log" globally (for all the databases)
- These traces enabled until the Server restarted (or) DBCC TraceOff

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Jasminej, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response