Where do I find the settings for this?
Blocked Sessions (Count): Number of sessions on the SQL Server instance being blocked by other sessions holding requested locks. Note: The “Non-Query activities>Capture deadlocks (SQL 2005+)” must be enabled for this alert to function.
Looks like this text is out of date. Go to Server Properties, then Activity Monitor, and ensure the Activity Monitor is enabled and that deadlocks are being captured.
Still trying to solve this issue.
We are currently using Idera DM 10.0.1.2206
All instances in server properties show, activity monitor enabled=enablem, deadlock monitoring=enabled/running.
Yet l keep getting emails like below. Any further ideas/solutions please?
5/23/2016 3:01:24 PM, Blocked Sessions (Count) on ####### is Critical.
SQL Server instance deqlead-lims has 1 sessions which are blocked by other sessions.
Yes, periodically I forget why I am ignoring this in the email and come back to this....LOL
Powered by IDERA