MAXDB performance

Purpose

Database performance must be monitored closely in order to detect any drop and 
avoid blocking situation for your applications and users

Use the configuration table to setup monitoring rules on available 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.

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

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