This is a nice article that talks about how to find more details about deadlock.
Finding and Extracting deadlock information using Extended Events
http://social.technet.microsoft.com/wiki/contents/articles/31280.finding-and-extracting-deadlock-information-using-extended-events.aspx
Using TRY/CATCH to handle the deadlock
https://technet.microsoft.com/en-us/library/aa175791(v=sql.80).aspx
No comments:
Post a Comment