How can we help you today? How can we help you today?

Does SQL Monitor report deadlock when deadlock error is handled in try catch?

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
XanMan
0

Comments

1 comment

Sort by
  • Russell D
    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.
    Russell D
    0

Add comment

Please sign in to leave a comment.