Does SQL Monitor report deadlock when deadlock error is handled in try catch?
XanMan
Posts: 1 New member
Hello,
We have a cleanup operation in our system that was generating deadlocks. We think it is fixed now but the fix included introducing the standard pattern of using a try catch to catch 1205 errors and retry up to x times. We would still like to know if the deadlock is occurring even when it is caught and the clean-up is executed successfully in a retry. Will SQL Monitor report these "caught" deadlocks.
Thanks
Paul
We have a cleanup operation in our system that was generating deadlocks. We think it is fixed now but the fix included introducing the standard pattern of using a try catch to catch 1205 errors and retry up to x times. We would still like to know if the deadlock is occurring even when it is caught and the clean-up is executed successfully in a retry. Will SQL Monitor report these "caught" deadlocks.
Thanks
Paul
Tagged:
Best Answer
-
Russell D
Posts: 1,324 Diamond 5
SQL Monitor should alert on this - we collect the deadlocks from extended events and think that in this scenario the deadlock would appear as an event which therefore should in turn raise an alert.
Have you visited our Help Centre?
