Sybase deadlocks

Purpose

Deadlocks can significantly reduce the performance of the applications and the response time for the users. This is usually reflecting a blocking situation which can last a long time.
It is therefore very important to detect deadlocks and act rapidly to resolve them if necessary.

Configuration hints

Surveillance table:

This is a table of rules that you can use to configure and customize the configuration.

Each line of the table will define a rule of monitoring.

You can combine multiple rules to cover different cases.

Within a rule, you can configure a threshold for the number of deadlocks to reach before sending an alert

Max dead locks:

Use the multi-threshold syntax to set multiple threshold/severity associations: G2W:1 W2M:5 (Green To Warning, Warning To Major, etc...).

An alarm of the corresponding severity will be sent if the number of deadlocks is reaching the threshold.

Set 0 in the field if unused

This monitor will look for deadlocks that occurred since the last check. It will cope with server restart up to a period of 2 hours of down time.

Surveillance table

Parameter	Description
Active	If checked, the rule is enabled and will be processed.
Max deadlocks	The threshold for the maximum number of deadlocks, Use the multi-threshold syntax (e.g., G2W:1 W2M:5)
Auto clear	If set, the generated alarms will be automatically cleared from the console if the alarm condition is no longer met
Alarm tag	Allows custom text to be added to the alarm message. The %MSG% variable will contain the actual generated message and can be used, for example, as “my_prefix %MSG% my_suffix”. By default, the tag will be used as a prefix
Exclusive	Defines if matching object names are removed from subsequent rules
Alarm	Defines if alerting is active for this rule
Metric	Defines if metric generation is active for this rule
Report	If checked, this rule will be used for showing threshold and severity in the daily report

Examples

Here is an example based on the format and the image provided:

Active	Object Name	Max deadlocks	Severity	Aggregates	Auto clear	Alarm tag	Exclusive	Alarm	Report
true	*	G2W:1 W2M:5	WARNING	true	false	true	true	true

Effect : A alarm is sent if a deadlock is found and matching with “max deadlocks” since the last check