====== MAXDB performance====== ===== Purpose ===== Database performance must be monitored closely in order to detect any drop and avoid blocking situation for your applications and users ===== Configuration hints ===== * Use the configuration table to setup monitoring rules on available performance metrics ====Performance metrics==== * You can create a rule for a selected list of metrics: * DEADLOCKS * DEADLOCKS_PER_TABLE * USED_SPACE_IN_FILES * DATA_USED_SPACE * LOG_USED_SPACE * DATAFULL * CACHE_HIT_RATIO * CHECK_ADMIN_STATE * Set the ''//Threshold//'' field with the appropriate value * If the threshold is reached, an alarm will be sent * You can use multi threshold syntax, otherwise the ''//Severity//'' field will be used to set alarm severity. ===== Surveillance table ===== ^Parameter^Description^ ^Active|If checked, the rule is enabled and will be processed| ^Performance metric|The metric to monitor| ^Threshold|The maximum value for the selected metric| ^Severity|Defines the severity of the alert generated (unless multi threshold syntax is used)| ^Auto clear|If set, the monitor will CLEAR any previous alarm if the conditions of those alarms are not true anymore| ^Alarm tag|You can define some text to use as a prefix of the alarm message generated by the current rule| ^Alarm|Defines if an alarm has to be generated for the given rule| ^Metric|Defines if a metric has to be generated for the given rule| ===== Generated metrics ===== ^metricId^metricUnit^metricTarget^metricDescription^ |MAXDB_DEADLOCK_COUNT|count| |The number of deadlocks| |MAXDB_USED_SPACE_IN_FILES_PERC|%|FILE|The used space per file| |CACHE_HIT_RATIO|%|CACHE|The hit ratio per cache| |DATA_USED_SPACE_PERC|%| |The space used by DATA| |LOG_USED_SPACE_PERC|%| |The space used by LOG| |ADMIN_STATE|boolean| |Sends 1 if admin state is ON|