Redpeaks V6.8
Trouble shooting
Monitors Guide
Trouble shooting
Monitors Guide
Add this page to your book
Remove this page from your book 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 |