products:promonitor:6.8:monitorsguide:sybase:sybaseperformance

Sybase performance

Purpose

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.

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 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).

Surveillance table

ParameterDescription
ActiveIf checked, the rule is enabled and will be processed
Total CPU usageThe threshold for the maximum total CPU usage (%) of the DB. Use multi threshold syntax.
Thread poolA filter on the thread pool name. You can use regexp, white list or black list, use star for all.
Min TP idle thresholdThe minimum expected average idle time for the threads of a given spool
Auto clearIf set, clears the alarms that are no longer generated.
Alarm tagThis 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.
AlarmDefines if the alerting is active for this rule.
MetricDefines if the metric generation is active for this rule.
ReportIf checked, this rule will be used for showing threshold and severity in the daily report

Examples

ActiveTotal CPU usageThread poolMin TP idle thresholdAuto clearAlarm tagAlarmMetricReport
trueG2W:90 W2M:95*G2W:60 W2M:40true truetruefalse

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%)

Generated metrics

metricIdmetricUnitmetricTargetmetricDescription
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.
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/sybase/sybaseperformance.txt · Last modified: 2020/05/29 16:16 (external edit)