Deadlocks not raising alert
gerhau
Posts: 19
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?
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?
Gert Hauan
Comments
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
I have now sent a mail to support@red-gate.com with the info you asked for.