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

Parameter	Description
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

Examples

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

Generated metrics

metricId	metricUnit	metricTarget	metricDescription
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.