- Install Promonitor
This monitor is meant to detect when the database is reaching its limits in processing capabilities. Such situations will impact response times for programs and users. It will check database CPU and threads usage.
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 the maximum total CPU usage ratio and the minimum idle time ratio for threads of each pool.
Total CPU usage: Use the multi-threshold syntax to set multiple threshold/severity associations: G2W:90 W2M:95 M2C:98 (Green To Warning, Warning To Major, etc…). An alarm of the corresponding severity will be sent if the CPU usage is over threshold. Set 0 in the field if unused
Thread pool idle ratio: For each thread pool, this monitor will collect the average idle ratio of its threads If the idle ratio is below a threshold, and alarm can be sent. Use the multi threshold syntax to set multiple severity levels. The average idle ratio is computed between two checks. You can then set a filter on the thread pool name if you need to set a specific rule for it.
Computing method: CPU and idle ratio computing is based on two readings: The current one and the one from the last check. If the monitor runs every 15 minutes, CPU and idle ratio will be the average of the last 15 minutes. Use the schedule time to increase or decrease the average period.
Rules order: Rules are processed following their order in the table. One given pool can only be processed once, it will be ignored by subsequent rules. Therefore you MUST define specific rules (for a give pool) before general ones (for all).
|Active||If checked, the rule is enabled and will be processed|
|Total CPU usage||The threshold for the maximum total CPU usage (%) of the DB. Use multi threshold syntax.|
|Thread pool||A filter on the thread pool name. You can use regexp, white list or black list, use star for all.|
|Min TP idle threshold||The minimum expected average idle time for the threads of a given spool|
|Auto clear||If set, clears the alarms that are no longer generated.|
|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|
|Active||Total CPU usage||Thread pool||Min TP idle threshold||Auto clear||Alarm tag||Alarm||Metric||Report|
|true||G2W:90 W2M:95||*||G2W:60 W2M:40||true||true||true||false|
Effect : A WARNING alarm is sent if CPU usage is over 90% (MAJOR if over 95%). A WARNING alarm is sent for every pool of threads with an idle ratio lower than 60% (MAJOR if lower than 40%)
|DATABASE_CPU_UTILIZATION||%||[PERIOD]||The average total CPU utilization within a time period set as TARGET|
|DATABASE_THREAD_POOL_IDLE_RATIO||%||[POOL][PERIOD]||The average idle ratio of the trheads of the given pool, within a period of time.|