products:promonitor:6.8:monitorsguide:sybase:sybasedeadlocks

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

ParameterDescription
ActiveIf checked, the rule is enabled and will be processed.
Max deadlocksThe threshold for the maximum number of deadlocks, Use the multi-threshold syntax (e.g., G2W:1 W2M:5)
Auto clearIf set, the generated alarms will be automatically cleared from the console if the alarm condition is no longer met
Alarm tagAllows 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
ExclusiveDefines if matching object names are removed from subsequent rules
AlarmDefines if alerting is active for this rule
MetricDefines if metric generation is active for this rule
ReportIf 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:

ActiveObject NameMax deadlocksSeverityAggregatesAuto clearAlarm tagExclusiveAlarmReport
true*G2W:1 W2M:5WARNINGtruefalse truetruetrue

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

/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/sybase/sybasedeadlocks.txt · Last modified: 2024/07/25 15:02 by jtbeduchaud