Victimless deadlocks

kevriley · February 6, 2019 10:16AM

From 8.0.22, the release notes state

victimless (eg Exchange Event) deadlocks are excluded by default

In the alert configuration for Deadlock alerts we have the checkbox

Alert when deadlock has no victim process

Does ticking this override the default setting?

Russell D · February 6, 2019 2:24PM

Hi Kevan, yes it should override the default.

kevriley · February 6, 2019 2:49PM

I thought so. It isn't though, as I'm seeing deadlocks in the sqlmonitor_session extended event and despite this checkbox being ticked, I didn't get any alerts

Russell D · February 7, 2019 11:09AM

Can you send in some details please Kevan?

kevriley · February 7, 2019 11:26AM

Sure - do you want me to open a support ticket @Russell D ?

Russell D · February 7, 2019 11:30AM

It's probably easier yes.

Victimless deadlocks

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk