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

Deadlocks not raising alert

Hi

There seems to be some deadlocks not being alerted by SQL Monitor. We usually see this if the deadlock is triggered by a running job.
The error log (in SSMS) for the failing job will show that it was beacuse it was a deadlock victim.
Is this known behavior?
gerhau
0

Comments

2 comments

Sort by
  • wendy.mitchell
    Hi Gert

    Thank you for your post.

    1. Could you confirm what version of SQL Monitor you are using?
    2. Could you check if the trace flag 1204 or 1222 are enabled?
    3. Could you also forward us the log files, following the instructions in the link below:
    Documentation link

    We will then be able to investigate further.

    Many Thanks
    Regards
    Wendy Mitchell
    Product Support Engineer
    wendy.mitchell
    0
  • gerhau
    Hi

    I have now sent a mail to support@red-gate.com with the info you asked for.
    gerhau
    0

Add comment

Please sign in to leave a comment.