Redpeaks V6.8
Trouble shooting
Monitors Guide
Trouble shooting
Monitors Guide
This monitor will look for locks on table objects and generate alarms if too many locks are waiting since a given time
Multi severity threshold
Exclusions:
Parameter | Description |
---|---|
Active | Use this field to activate or deactivate a line of configuration. |
Client | A filter on the client. |
Table Name | The name of the table to filter. You can use regular expressions, or * to match any object. |
Max wait time (min) | The threshold for the maximum time a lock can be waiting, in minutes. |
Max locks | The maximum number of lock waiting since more that the configured waiting time. |
Aggregate | If checked, the alarm will indicate how many matching locks are waiting since too long time. If not checked, it will send an alarm per table having too many waiting locks. |
Severity | The default level of severity of the alarm generated by this line of surveillance. |
Auto clear | If checked, the alarm will be cleared as soon as the alarm condition is not met 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 | If checked, this line of surveillance will be used for alarm generation. |
Metric | If checked, this line of surveillance will be used for metric generation. |
Report | If checked, this line of surveillance will used for showing threshold and severity in the daily report |
Active | Client | Table Name | Max wait time (min) | Max locks | Aggregate | Severity | Auto clear | Alarm tag | Alarm | Metric | Report |
---|---|---|---|---|---|---|---|---|---|---|---|
true | * | * | 600 | 10 | false | MAJOR | true | true | false | false |
Effect : Sends a MAJOR alarm for each table having more than 10 waiting locks since more than 600 minutes.
Active | Client | Table Name | Max wait time (min) | Max locks | Aggregate | Severity | Auto clear | Alarm tag | Alarm | Metric | Report |
---|---|---|---|---|---|---|---|---|---|---|---|
true | 800 | TBC.* | 480 | 1 | true | WARNING | true | true | false | false |
Effect : Sends a WARNING alarm if, in client 800, at least 1 table with name starting with TBC has a lock since more than 480 minutes
metricId | metricUnit | metricTarget | metricDescription |
---|---|---|---|
LONG_EXCLUSIVE_LOCKS_NUMBER | Seconds | TABLE | The number of exclusive locks waiting on the table |