In SQL Monitor, I want to...

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.

For example
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!

42 votes
Vote
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
You have left! (?) (thinking…)
Ash.Tickett shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  Adam responded  · 

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.

Thanks,
SQL Monitor Development Team

4 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Luke L commented  ·   ·  Flag as inappropriate

    This idea has been around for 1.5 years... any chance of getting some traction for this?

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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...

Feedback and Knowledge Base