====== 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 dead locks|The threshold for the maximum number of deadlocks. You must use the multi-threshold syntax (G2W:1 W2M:5 etc...)|
^Auto clear|If set, the generated alarms will be automatically cleared from the console if the alarm condition is not fulfilled anymore|
^Alarm tag|This field allows to add custom text within the alarm message. %MSG% variable will contain the actual generated message and can be used such as: "my_prefix %MSG% my_suffix". By default, tag will be used as prefix.|
^Alarm|Defines if the alerting is active for this rule.|
^Metric|Defines if the 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 =====
 
^Active^Max messages^Auto clear^Alarm tag^Alarm^Metric^Report^
|true|G2M:1|false| |true|true|false|

**Effect** : A MAJOR alarm is sent if a deadlock is found since the last check