Redpeaks V6.8
Trouble shooting
Monitors Guide
Trouble shooting
Monitors Guide
The transaction log file contains information that allows Sybase to recover from a system failure. The transaction log is also required for auditing. Sybase IQ records in the transaction log the information necessary to recover from a system failure. Although the information logged is small for each committed transaction, the transaction log continues to grow in size. In systems with a high number of transactions that change data, over a period of time the log can grow to be very large. It becomes then crucial being able to monitor some transaction log key factors such as the number of log pages already used, the number of log pages reserved for rollbacks or the number of log pages that has not been used yet.
Monitor features include :
Unit of measure of the monitor:
Select the unit of measure you want the monitor to fetch monitored features data, it includes : KB, MB, GB, PAGES
Surveillance table:
Monitored feature :
Select the specific Sybase transaction log feature you want to monitor (Free pages, Used pages, CLR Pages)
Feature threshold :
Unit :
Select “As monitor” if you want to monitor data expressed in the same unit of measure as the monitor or select “Percentage” if you prefer values to be monitored this way.
Unit of measure | Select the unit of measure you want the monitor to fetch the requested information (KB, MB, GB, Pages) |
---|
Parameter | Description |
---|---|
Active | Use this field to activate or deactivate a line of configuration. |
Monitored feature | select one of the supported features : Free pages, Used pages, CLR pages |
Feature threshold | The threshold setting for the selected feature You can use the multi threshold syntax (i.e. : G2W:40 W2C:5) . |
Unit | Select “As monitor” if threshold values are expressed in the monitor generic Unit of measure - see “Unit of measure” in the Atomic fields section - , or select “Percentage” if threshold setting are expressed as percentage values |
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 | Monitored feature | Feature threshold | Unit | Auto clear | Alarm tag | Alarm | Metric | Report |
---|---|---|---|---|---|---|---|---|
true | Used pages | G2W:70 W2C:85 | Percentage | true | true | true | true |
Effect : For this rule, used pages within the trasaction log file will be monitored
A WARNING alarm is sent if used pages are monitored at 70% or more, a CRITICAL alarm if 85% or more.
metricId | metricUnit | metricTarget | metricDescription |
---|---|---|---|
SAP_DATABASE_TRANS_LOG_CLR_PAGES_KB | KB | CLR_PAGES | fetched CLR pages value, expressed in KB |
SAP_DATABASE_TRANS_LOG_CLR_PAGES_MB | MB | CLR_PAGES | fetched CLR pages value, expressed in MB |
SAP_DATABASE_TRANS_LOG_CLR_PAGES_GB | GB | CLR_PAGES | fetched CLR pages value, expressed in GB |
SAP_DATABASE_TRANS_LOG_CLR_PAGES_NUMBER | Number of pages | CLR_PAGES | fetched CLR pages value, expressed in number of pages |
SAP_DATABASE_TRANS_LOG_CLR_PAGES_PERCENT | Percentage | CLR_PAGES | fetched CLR pages value, expressed in percentage |
SAP_DATABASE_TRANS_LOG_FREE_PAGES_KB | KB | FREE_PAGES | fetched free pages value, expressed in KB |
SAP_DATABASE_TRANS_LOG_FREE_PAGES_MB | MB | FREE_PAGES | fetched free pages value, expressed in MB |
SAP_DATABASE_TRANS_LOG_FREE_PAGES_GB | GB | FREE_PAGES | fetched free pages value, expressed in GB |
SAP_DATABASE_TRANS_LOG_FREE_PAGES_NUMBER | Number of pages | FREE_PAGES | fetched free pages value, expressed in number of pages |
SAP_DATABASE_TRANS_LOG_FREE_PAGES_PERCENT | Percentage | FREE_PAGES | fetched free pages value, expressed in percentage |
SAP_DATABASE_TRANS_LOG_USED_PAGES_KB | KB | USED_PAGES | fetched used pages value, expressed in KB |
AP_DATABASE_TRANS_LOG_USED_PAGES_MB | MB | USED_PAGES | fetched used pages value, expressed in MB |
SAP_DATABASE_TRANS_LOG_USED_PAGES_GB | GB | USED_PAGES | fetched used pages value, expressed in GB |
SAP_DATABASE_TRANS_LOG_USED_PAGES_NUMBER | Number of pages | USED_PAGES | fetched used pages value, expressed in number of pages |
SAP_DATABASE_TRANS_LOG_USED_PAGES_PERCENT | Percentage | USED_PAGES | fetched used pages value, expressed in percentage value |