Block Specific Deadlocks by Lock Details
We've just updated to SQL Monitor 6. We was hoping there was a feature in this to change alert settings for Deadlocks with specific lock details rather than just all Deadklocks.
we don't want email alerts on: Deadlock 'object: ReportServerTempDB.dbo.SessionLock, lock mode: Exclusive (X), index: IDX_SessionLock
However we wish to receive emails when: Deadlock 'dbid: 6, object id: 72057594038845440, index id: (9bf78693a4b4)'
However this feature doesn't exist. Would be great to have added to an update in the near future!
Thanks for this suggestion and the comments.
As previously announced, since version 8.0.22 (released November 13th, 2018) Deadlock (XE) alerts can now be filtered by database, login name & resource, and victimless (eg Exchange Event) deadlocks are excluded by default.
We are marking this as complete, but please do let us know if you have any further feedback.
SQL Monitor Development Team
Luke L commented
This idea has been around for 1.5 years... any chance of getting some traction for this?
Mark Anderson commented
+ 1 on This is making the whole SQL Monitor 6 Alerts utterly useless, this issue must be fixed!
The specific removal of dead locks would be great, but this issue especially with the ReportServerTempDB is a false alert, over and over again.
This is making the whole SQL Monitor 6 Alerts utterly useless, this issue must be fixed!
Luke L commented
Agreed, it would be helpful to be able to disable deadlocks for certain databases or processes that are know to have problems but which we are unable to resolve due to vendor support issues etc...