products:promonitor:6.8:monitorsguide:sybase:sybasedatabasesize

Sybase database size

Purpose

Disk space is a critical resource for any database, to persist database and log data.
This monitor is meant to detect situations where allocated disk space is running low.

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 a maximum data and log used space.

Maximum data and log used space:

  • Use the multi-threshold syntax to set multiple threshold/severity associations: G2W:80 W2M:85 (Green To Warning, Warning To Major, etc…).
  • An alarm of the corresponding severity will be sent if the used space is reaching a threshold.
  • Set 0 in the field if unused
  • You can set a DB specific rule by using the DB name filter. Use * to match any DB name, or regular expression.

Rules order:

  • Rules are processed following their order in the table.
  • One given DB can only be processed once, it will be ignored by subsequent rules.
  • Therefore you MUST define specific rules (for a given DB) before general ones (for all).

Surveillance table

ParameterDescription
ActiveIf checked, the rule is enabled and will be processed
DB nameA filter to match only a specific DB name, can use regular expression, white or black list
Max DATA used space (%)The threshold for the DATA usage on disk. You can use the multi threshold syntax (Like G2W:80 W2C:90)
Max LOG used space (%)The threshold for the LOG usage on disk. You can use the multi threshold syntax (Like G2W:80 W2C:90)
SeverityThe default severity used if multi threshold syntax is not used.
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

ActiveDB nameMax DATA used space (%)Max LOG used space (%)SeverityAuto clearPrefixAlarmMetricReport
true*8590MAJORtrue truetruefalse

Effect : A MAJOR alarm will be sent if DATA space is used at 85% of more (and 90% for LOG space), for any database.

Examples

ActiveDB nameMax DATA used space (%)Max LOG used space (%)SeverityAuto clearPrefixAlarmMetricReport
truemaster0G2W:90 W2C:95MAJORtrue truetruefalse

Effect : A WARNING alarm will be sent if LOG space of master DB is used at 90% or more (CRITICAL if 95%)

Generated metrics

metricIdmetricUnitmetricTargetmetricDescription
DATABASE_LOG_PERCENTAGE_USED_SPACE%[DB NAME]The LOG percentage usage of a given DB
DATABASE_DATA_PERCENTAGE_USED_SPACE%[DB NAME]The DATA percentage usage of a given DB
DATABASE_LOG_USED_SPACEGB[DB NAME]The LOG usage of the DB
DATABASE_DATA_USED_SPACEGB[DB_NAME]The DATA usage of the DB
DATABASE_TOTAL_LOG_SPACEMB[DB NAME]The total LOG space of the given DB
DATABASE_TOTAL_DATA_SPACEGB[DB NAME]The total DATA space of the given DB
/home/clients/8c48b436badcd3a0bdaaba8c59a54bf1/wiki-web/data/pages/products/promonitor/6.8/monitorsguide/sybase/sybasedatabasesize.txt · Last modified: 2024/05/01 18:35 (external edit)