Database - Monitoring Parameters

Here you will find detailed information about monitoring parameters for Database monitored objects.

Monitoring parameters are the mechanism for you to configure how your systems are monitored. They are how you set configuration of how the agent runs, how checks are executed, thresholds for checks (when does a check go critical or warning) and much more. All Monitoring Parameters have a carefully chosen default value. As soon as you add a new system, Avantra uses these defaults. You may change these defaults by defining a parameter and by modifying its values. Monitoring Parameters can be defined for a single system, or for collections of systems using Monitoring Parameter Sets. You can also define your own Custom Monitoring Parameters for use within Custom Checks and automations.

note

For a Database instance of an SAP System, the Database Monitoring Parameters are treated as SAP System Monitoring Parameters.

ADADataExCrit

If the predicted point in time when the data area is exceeded is within the upcoming ADADataExCrit hours, the check status of ADA_DATAAREA is set to Critical.

Reference Data


Configures Checks	ADA_DATAAREA
Default Value	1
Unit	Hours

ADADataExWarn

If the predicted point in time when the data area is exceeded is within the upcoming ADADataExWarn hours, but not within the upcoming ADADataExCrit hours, the check status of ADA_DATAAREA is set to Warning, unless the ADADataUsageCrit threshold is exceeded.

Reference Data


Configures Checks	ADA_DATAAREA
Default Value	12
Unit	Hours

ADADataForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	ADA_DATAAREA
Default Value	Active
Unit	Enum

ADADataUsageCrit

If the data area usage exceeds the ADADataUsageCrit threshold, the check status is set to Critical.

You can define the threshold either in percentage of the total size of the resource, or in KB, MB, or GB values of the remaining free space. In the first case, the parameter gets effective if the usage measured in % of the total space is higher than the defined threshold. In the second case the parameter gets effective if the remaining free space is lower than the defined threshold.

Reference Data


Configures Checks	ADA_DATAAREA
Default Value	98 %
Unit	% or KB/MB/GB

ADADataUsageWarn

If data area usage exceeds the ADADataUsageWarn threshold, but does not exceed the ADADataUsageCrit threshold, the check status is set to Warning, unless the data area is exhausted in less than ADADataExCrit hours.

Reference Data


Configures Checks	ADA_DATAAREA
Default Value	95 %
Unit	% or KB/MB/GB

ADALogExCrit

If the predicted point in time when the log area is exceeded is within the upcoming ADALogExCrit hours, the check status of ADA_LOGAREA is set to Critical.

Reference Data


Configures Checks	ADA_LOGAREA
Default Value	1
Unit	Hours

ADALogExWarn

If the predicted point in time when the log area is exceeded is within the upcoming ADALogExWarn hours, but not within the upcoming ADALogExCrit hours, the check status of ADA_LOGAREA is set to Warning, unless the ADALogUsageCrit threshold is exceeded.

Reference Data


Configures Checks	ADA_LOGAREA
Default Value	12
Unit	Hours

ADALogForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	ADA_LOGAREA
Default Value	Active
Unit	Enum

ADALogUsageCrit

If the log area usage exceeds the ADALogUsageCrit threshold, the check status is set to Critical.

Reference Data


Configures Checks	ADA_LOGAREA
Default Value	95 %
Unit	% or KB/MB/GB

ADALogUsageWarn

If log area usage exceeds the ADALogUsageWarn threshold, but does not exceed the ADALogUsageCrit threshold, the check status is set to Warning, unless the data area is exhausted in less than ADADataExCrit hours.

Reference Data


Configures Checks	ADA_LOGAREA
Default Value	80 %
Unit	% or KB/MB/GB

ANYBackupFullCritAge

If the last successful full backup run is older than ANYBackupFullCritAge days, the check status is set to Critical.

Reference Data


Configures Checks	ADA_BACKUP
Default Value	15
Unit	Days

ANYBackupFullWarnAge

If the last successful full backup run is older than ANYBackupFullWarnAge days, but still below ANYBackupFullCritAge, the check status is set to Warning.

Reference Data


Configures Checks	ADA_BACKUP
Default Value	8
Unit	Days

ANYBackupSelectRange

ANY_Backup looks for ANYBackupSelectRange days back to find maintenance reports of backups. The default value is 60 days, so usually, there is no need to change this parameter since backups must be made far more often.

Reference Data


Configures Checks	ADA_BACKUP
Default Value	60
Unit	Days

ANYConnectionsNumCrit

If the number of connections to the database exceeds ANYConnectionsNumCrit, the check status of ANY_Connections is set to Critical.

Reference Data


Configures Checks	ANY_Connections
Default Value	200
Unit	Number

ANYConnectionsNumWarn

If the number of connections to the database exceeds ANYConnectionsNumWarn, but is still below ANYConnectionsNumCrit, the check status of ANY_Connections is set to Warning.

Reference Data


Configures Checks	ANY_Connections
Default Value	100
Unit	Number

ANYDBExCrit

If the predicted point in time when the dbspace is exceeded is within the upcoming ANYDBExCrit hours, the check status of ANY_DBSpaces is set to Critical.

Reference Data


Configures Checks	ANY_DBSpaces
Default Value	1
Unit	Hours

ANYDBExWarn

If the predicted point in time when the dbspace is exceeded is within the upcoming ANYDBExWarn hours, but not within the upcoming ANYDBExCrit hours, the check status of ANY_DBSpaces is set to Warning, unless the ANYDBUsageCrit threshold is exceeded.

Reference Data


Configures Checks	ANY_DBSpaces
Default Value	12
Unit	Hours

ANYDBForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	ANY_DBSpaces
Default Value	Active
Unit	Enum

ANYDBUsageCrit

If the dbspace usage exceeds the ANYDBUsageCrit threshold the check status is set to Critical.

Reference Data


Configures Checks	ANY_DBSpaces
Default Value	95 %
Unit	% or KB/MB/GB

ANYDBUsageWarn

If the data space usage of a database exceeds the ANYDBUsageWarn threshold the check status is set to Warning, unless the ANYDBUsageCrit threshold is exceeded.

Reference Data


Configures Checks	ANY_DBSpaces
Default Value	80 %
Unit	% or KB/MB/GB

ANYLogExCrit

If the predicted point in time when the transaction log space is exceeded is within the upcoming ANYLogExCrit hours, the check status of ANY_TransLog is set to Critical.

Reference Data


Configures Checks	None
Default Value	1
Unit	Hours

ANYLogExWarn

If the predicted point in time when the transaction log space is exceeded is within the upcoming ANYLogExWarn hours, but not within the upcoming ANYLogExCrit hours, the check status of ANY_TransLog is set to Warning, unless the ANYLogUsageCrit threshold is exceeded.

Reference Data


Configures Checks	None
Default Value	12
Unit	Hours

ANYLogForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	None
Default Value	Active
Unit	Enum

ANYLogUsageCrit

If the transaction log space usage exceeds the ANYLogUsageCrit threshold, the check status is set to Critical.

Reference Data


Configures Checks	None
Default Value	90 %
Unit	% or KB/MB/GB

ANYLogUsageWarn

If the transaction log space usage of a database exceeds the ANYLogUsageWarn threshold, the check status is set to Warning unless the ANYLogUsageCrit threshold is exceeded.

Reference Data


Configures Checks	None
Default Value	75 %
Unit	% or KB/MB/GB

ANYMessagesExclude

ANYMessagesExclude does exactly the same as ANYMessagesStatExclude, except that it configures daily check ANY_Messages. Please see documentation of ANYMessagesStatExclude below.

Reference Data


Configures Checks	ANY_Messages
Default Value
Unit	String

ANYMessagesNumCrit

Defines a Critical threshold for the ANY_Messages check. The check status will be Critical if the number of not excluded server messages with severity ERR is equal to or above ANYMessagesNumCrit.

Reference Data


Configures Checks	ANY_Messages
Default Value	1
Unit	Number

ANYMessagesNumWarn

Defines a Warning threshold for the ANY_Messages check. ANYMessagesNumWarn behaves exactly as ANYMessagesStatNumWarn, except that it configures daily check ANY_Messages

Reference Data


Configures Checks	ANY_Messages
Default Value	1
Unit	Number

ANYMessagesStatExclude

You can use this parameter to exclude certain server messages from being evaluated in ANY_MessagesStat check. There are two types of exclude specifications: a simple one, which filters on the server message text only, and an advanced one, which must be specified in the format msg_severity|msg_category|msg_text. A server message must match all three items of a fully-featured exclude specification to be excluded. Multiple exclude specifications must be separated by semicolon ;. Leading and trailing blank spaces before or after the semicolon ; or pipe | character are gently ignored.

You may use wildcards * or ? to specify the server message text.

Example: Excludes


Simple exclude spec on server message text only	`Starting checkpoint of *`
Advanced exclude spec filtering out ERR messages of category `CHKPT` and `OTHER`	`ERR\|CHKPT,OTHER\|checkpoint`
Advanced exclude spec filtering out ERR messages of any category with message text containing Shared Memory	`ERR\|\|Shared*Memory`
List of above exclude items	`Starting checkpoint of * ; ERR\|CHKPT,OTHER\|checkpoint ; ERR\|\|Shared*Memory`

Reference Data


Configures Checks	ANY_MessagesStat
Default Value
Unit	String

ANYMessagesStatNumCrit

Defines a Critical threshold for the ANY_MessagesStat check. ANYMessagesStatNumCrit behaves exactly as ANYMessagesNumCrit, except that it configures RealTime Monitoring check ANY_MessagesStat.

Reference Data


Configures Checks	ANY_MessagesStat
Default Value	1
Unit	Number

ANYMessagesStatNumWarn

Defines a Warning threshold for the ANY_MessagesStat check. The check status will be Warning if the number of not excluded server messages with severity ERR or WARN is equal to or above ANYMessagesStatNumWarn, unless the number of messages with severity ERR is equal to or above ANYMessagesStatNumCrit.

Reference Data


Configures Checks	ANY_MessagesStat
Default Value	1
Unit	Number

ANYMessagesStatTimespan

RealTime Monitoring check ANY_MessagesStat is designed to recover from check status Warning or Critical, so the check looks back for a time span defined by ANYMessagesStatTimespan only.

Reference Data


Configures Checks	ANY_MessagesStat
Default Value	60
Unit	Minutes

AutoChangeDetectionIgnore

AutoChangeDetectionIgnore is used to exclude parameters from System Change Auto Detection. If, for example, a parameter value changes regularly and this behavior is well-known, you may add the parameter to the exclude list. The parameter value is still updated in the Avantra Database, but no change record will be created. Since there are several change detection objects, you must prefix the list with a keyword to indicate the object type.

For Databases, only DBPARAM is currently supported. Wildcard * is supported to define multiple parameters, e.g. DBPARAM: *MEMORY*, CPU_COUNT.

Reference Data


Configures	System Change Auto Detection
Default Value
Unit	String

BackupAgeCrit

Description

If the last successful Backup is older than BackupAgeCrit days, the check status is set to Critical. You can override this value on a per-day level using the corresponding Monitoring Parameter Exception.

Reference Data


Configures Checks	ADA_BACKUP, ORA_BACKUP, DB2_BACKUP, MSS_DBBACKUP, ORA_BRBACKUP, HDB_Backup, SYB_Backup, ANY_Backup, SIQ_Backup
Default Value	7
Unit	Days

BackupAgeWarn

If the last successful Backup is older than BackupAgeWarn days, but not older than BackupAgeCrit days, the check status is set to Warning. You can override this value on a per-day level using the corresponding Monitoring Parameter Exception.

Reference Data


Configures Checks	ADA_BACKUP, ORA_BACKUP, DB2_BACKUP, MSS_DBBACKUP, ORA_BRBACKUP, HDB_Backup, SYB_Backup, ANY_Backup, SIQ_Backup
Default Value	1
Unit	Days

BackupResetRTMTime

This parameter defines the time period (in hours) after which a Warning or Critical DB2_BACKUPSTAT or ORA_BRBACKUPSTAT check status are set back to OK. This is to avoid showing the Warning or Critical condition all the time.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT, DB2_BACKUPSTAT
Default Value	8
Unit	Hours

DB2BackupStatWaitTime

Defines the time interval between two DB2_BACKUPSTAT checks. By default the check runs in the BASIC cycle.

Reference Data


Configures Checks	None
Default Value	10
Unit	Minutes

DB2CBOMaxAge

Defines the maximum age for the DB2 cost based optimizer statistics update where statistics are considered as up to date. DB2_CBO_STATS counts the number of tables/indexes not older than DB2CBOMaxAge. You may adapt this parameter if your CBO update runs are scheduled more or less frequently.

Reference Data


Configures Checks	DB2_CBO_STATS
Default Value	7
Unit	Days

DB2CBONumEntriesUpdCrit

If the number of tables or indexes with statistics not older than DB2CBOMaxAge days is below DB2CBONumEntriesUpdCrit, DB2_CBO_STATS result will be Critical.

Reference Data


Configures Checks	DB2_CBO_STATS
Default Value	1000
Unit	Number

DB2CBONumEntriesUpdWarn

If the number of tables or indexes with statistics not older than DB2CBOMaxAge days is below DB2CBONumEntriesUpdWarn but not below DB2CBONumEntriesUpdCrit, the DB2_CBO_STATS result will be Warning.

Reference Data


Configures Checks	DB2_CBO_STATS
Default Value	5000
Unit	Number

DB2DBRemote

You may set this parameter if the monitoring Avantra Agent has no access to the filesystem holding the DB2 installation, e.g. if you are using Agentless Monitoring.

In this case, the DB2_FSLOGARCH and DB2_DIAGLOG checks are not executed.

Reference Data


Configures Checks	DB2_FSLOGARCH, DB2_DIAGLOG
Default Value	0
Unit	Boolean

DB2DiagLogCountCrit

Defines a Critical threshold for the DB2_DIAGLOG check. The check status will be Critical if that many log entries considered as critical are found.

Reference Data


Configures Checks	DB2_DIAGLOG
Default Value	1
Unit	Number

DB2DiagLogCountWarn

Defines a Warning threshold for the DB2_DIAGLOG check. The check status will be Warning if that many log entries considered as warning are found unless the DB2DiagLogCountCrit critical threshold is exceeded.

Reference Data


Configures Checks	DB2_DIAGLOG
Default Value	1
Unit	Number

DB2DiagLogExprCrit

Designates an entry in the DB2 diagnostics log as critical.

Reference Data


Configures Checks	DB2_DIAGLOG
Default Value	('%%level%%' eq 'Severe')
Unit	Expression

DB2DiagLogExprWarn

Designates an entry in the DB2 diagnostics log as warning.

Reference Data


Configures Checks	DB2_DIAGLOG
Default Value	('%%level%%' eq 'Error')
Unit	Expression

DB2DiagLogTimeSpan

Consider only the last DB2DiagLogTimeSpan minutes of the log file.

Reference Data


Configures Checks	DB2_DIAGLOG
Default Value	60
Unit	Minutes

DB2ExpSQLExclude

Programs executing SQL statements on this list are not considered for the check result. Wildcard * is allowed. Multiple entries must be separated by (space). If your statement includes a space character, please escape it with a backslash .

Reference Data


Configures Checks	DB2_ExpSQL
Default Value	%_T*
Unit	String

DB2ExpSQLExcludeShow

Defines whether or not excluded statements, which will not contribute to the check result, are displayed.

Reference Data


Configures Checks	DB2_ExpSQL
Default Value	0
Unit	Boolean

DB2ExpSQLLogicalReadCrit

If for a particular SQL statement the amount of logical reads exceeds DB2ExpSQLLogicalReadCrit percent of the total number of reads of all statements, the check turns to Critical.

Reference Data


Configures Checks	DB2_ExpSQL
Default Value	10
Unit	%

DB2ExpSQLLogicalReadWarn

If for a particular SQL statement the amount of logical reads exceeds DB2ExpSQLLogicalReadWarn percent of the total number of reads of all statements but does not exceed DB2ExpSQLLogicalReadCrit, the check turns to Warning.

Reference Data


Configures Checks	DB2_ExpSQL
Default Value	5
Unit	%

DB2ExpSQLPhysicalReadCrit

If for a particular SQL statement the amount of physical reads exceeds DB2ExpSQLPhysicalReadCrit percent of the total number of reads of all statements, the check turns to Critical.

Reference Data


Configures Checks	DB2_ExpSQL
Default Value	10
Unit	%

DB2ExpSQLPhysicalReadWarn

If for a particular SQL statement the amount of physical reads exceeds DB2ExpSQLPhysicalReadWarn percent of the total number of reads of all statements but does not exceed DB2ExpSQLPhysicalReadCrit, the check turns to Warning.

Reference Data


Configures Checks	DB2_ExpSQL
Default Value	5
Unit	%

DB2FSLogActiveCrit

If the usage of file systems where the DB2 active log directories are located exceeds the DB2FSLogActiveCrit threshold, the check status is set to Critical.

The file systems of the active logs are taken from the DB2 parameters logpath and mirrorlogpath.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	85 %
Unit	% or KB/MB/GB

DB2FSLogActiveWarn

If the usage of file systems where the DB2 active log directories are located exceeds the DB2FSLogActiveWarn threshold, the check status is set to Warning but only if the status is not Critical due to DB2FSLogActiveCrit.

The file systems of the active logs are taken from the DB2 parameters logpath and mirrorlogpath.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	70 %
Unit	% or KB/MB/GB

DB2FSLogArchCrit

If the log archive filesystem usage exceeds the DB2FSLogArchCrit threshold the check status is set to Critical. The log archive filesystem is discovered automatically by Avantra Agent.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	85 %
Unit	% or KB/MB/GB

DB2FSLogArchExCrit

If the predicted point in time when the filesystem limit is exceeded is within the upcoming DB2FSLogArchExCrit hours, the check result of DB2_FSLOGARCH is set to Critical.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	1
Unit	Hours

DB2FSLogArchExWarn

If the predicted point in time when the filesystem limit is exceeded is within the upcoming DB2FSLogArchExWarn hours, but not within the upcoming DB2FSLogArchExCrit hours, the check result of DB2_FSLOGARCH is set to Warning, unless the DB2FSLogArchExCrit threshold is exceeded.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	12
Unit	Hours

DB2FSLogArchForecast

Defines whether the Forecasting algorithm is active or inactive.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	Active
Unit	Enum

DB2FSLogArchWarn

If the log archive filesystem usage exceeds the DB2FSLogArchWarn threshold, but does not exceed the DB2FSLogArchCrit threshold, the check status is set to Warning.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	70 %
Unit	% or KB/MB/GB

DB2LogExCrit

If the predicted point in time when the log space limit is exhausted is within the upcoming DB2LogExCrit hours, the check result of DB2_LOGUSAGE is set to Critical.

Reference Data


Configures Checks	DB2_LOGUSAGE
Default Value	1
Unit	Hours

DB2LogExWarn

If the predicted point in time when the log space limit is exhausted is within the upcoming DB2LogExWarn hours, but not within the upcoming DB2LogExCrit hours, the check result of DB2_LOGUSAGE is set to Warning.

Reference Data


Configures Checks	DB2_LOGUSAGE
Default Value	12
Unit	Hours

DB2LogForecast

Defines whether the Forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	DB2_LOGUSAGE
Default Value	Active
Unit	Enum

DB2LogUsageCrit

If the log space exceeds the DB2LogUsageCrit threshold, the check status is set to Critical.

Reference Data


Configures Checks	DB2_LOGUSAGE
Default Value	95 %
Unit	% or KB/MB/GB

DB2LogUsageWarn

If the log space exceeds the DB2LogUsageWarn threshold, but does not exceed the DB2LogUsageCrit threshold, the check status is set to Warning.

Reference Data


Configures Checks	DB2_LOGUSAGE
Default Value	80 %
Unit	% or KB/MB/GB

DB2NumFailArchLogsCrit

If the number of transaction log files located in the Failover Archive Path directory is above DB2NumFailArchLogsCrit, the check status is set to Critical. The Failover Archive Path directory is taken from the DB2 parameter failarchpath.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	5
Unit	Number

DB2NumFailArchLogsWarn

If the number of transaction log files located in the Failover Archive Path directory is above DB2NumFailArchLogsWarn but below DB2NumFailArchLogsCrit, the check status is set to Warning. The Failover Archive Path directory is taken from the DB2 parameter failarchpath.

Reference Data


Configures Checks	DB2_FSLOGARCH
Default Value	1
Unit	Number

DB2TableSpaceExCrit

If the predicted point in time when the tablespace limit is exceeded is within the upcoming DB2TableSpaceExCrit hours, the check result of DB2_TABLESPACES is set to Critical.

Reference Data


Configures Checks	DB2_TABLESPACES
Default Value	1
Unit	Hours

DB2TableSpaceExWarn

If the predicted point in time when the tablespace limit is exceeded is within the upcoming DB2TableSpaceExWarn hours, but not within the upcoming DB2TableSpaceExCrit hours, the check result of DB2_TABLESPACES is set to Warning, unless the DB2TableSpaceUsageCrit threshold is exceeded for some tablespace.

Reference Data


Configures Checks	DB2_TABLESPACES
Default Value	12
Unit	Hours

DB2TableSpaceForecast

Defines whether the Forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	DB2_TABLESPACES
Default Value	Active
Unit	Enum

DB2TableSpaceUsageCrit

If the use of one of the database tablespaces exceeds the DB2TableSpaceUsageCrit threshold, the check status is set to Critical.

Reference Data


Configures Checks	DB2_TABLESPACES
Default Value	98 %
Unit	% or KB/MB/GB

DB2TableSpaceUsageWarn

If the use of one of the database tablespaces exceeds the DB2TableSpaceUsageWarn threshold, but none of them exceeds the DB2TableSpaceUsageCrit threshold, the check status is set to Warning, unless the DB2TableSpaceExCrit threshold is exceeded for some tablespace.

Reference Data


Configures Checks	DB2_TABLESPACES
Default Value	95 %
Unit	% or KB/MB/GB

DBConnectErrsCrit

Configures the DBCONNECT check status to turn from Warning to Critical when the number of failed database connection attempts is higher than the number defined in this monitoring parameter.

Reference Data


Configures Checks	DBCONNECT, DBCONNECT, DBCONNECT, DBCONNECT, DBCONNECT, DBCONNECT, DBCONNECT
Default Value	1
Unit	Number

DBConnectJdbcUrl

Usually, the Avantra Agent automatically determines the URL to connect to the Database. In case the automatically determined URL does not work properly, you may override it using this parameter.

Available interpolations (macros):


`%HOST%`	Database host
`%PORT%`	Database port
`%DATABASE%`	Database name
`%HOSTPORT%`	HANA scale out host and port (only for HANA scale out environments). The format is `host1:port;host2:port;…` for any scaleout host.
`%RSID%`	Real SAP SID
`%USID%`	Unified SAP SID

Reference Data


Configures Checks	None
Default Value
Unit	String

FullBackupAgeCrit

If the last successful Full Backup is older than FullBackupAgeCrit days, the check status is set to Critical. You can define override this value on a per-day level using the corresponding Monitoring Exception Parameter.

Reference Data


Configures Checks	SYB_Backup, SIQ_Backup
Default Value	14
Unit	Days

FullBackupAgeWarn

If the last successful FullBackup is older than the defined number of days, but not older than FullBackupAgeCrit days, the check status is set to Warning. You can define override this value on a per-day level using the corresponding Monitoring Exception Parameter.

Reference Data


Configures Checks	SYB_Backup, SIQ_Backup
Default Value	7
Unit	Days

HDBAdmissionMaxRows

Maximum number of rows to return from table M_ADMISSION_CONTROL_EVENTS.

Reference Data


Configures Checks	HDB_Admission
Default Value	50
Unit	Number

HDBAdmissionStatus

Define if the check result shall be reported as warning or critical status.

Reference Data


Configures Checks	HDB_Admission
Default Value	Warning
Unit	Enum

HDBAdmissionTimeSpan

Configure how far in the past we are looking for entries in table M_ADMISSION_CONTROL_EVENTS.

Reference Data


Configures Checks	HDB_Admission
Default Value	10
Unit	Minutes

HDBAlertsErrorCountCrit

This monitoring parameter sets the HDB_Alerts check to critical, if the number of alerts with a rating Error found within a timespan defined by by HDBAlertsTimeSpan is equal to or above the defined threshold.

note

Please note that no matter how this parameter is defined, the check status will at least be warning if at least one alert with high priority is found within HDBAlertsTimeSpan.

Reference Data


Configures Checks	HDB_Alerts
Default Value	1
Unit	Number

HDBAlertsExcludeIDs

You can exclude alerts from contributing to the check status by specifying the alert's ID using this parameter. Multiple entries must be separated by spaces, comma, or semicolon. The syntax is forgiving, i. e. leading, trailing or multiple spaces will not harm and the right alerts will still be excluded as long as numeric values are found.

note

Excluded alerts will still be reported in the check result's overview table. They will be marked with string (Excluded) in the Alert ID column and will not be colored.

Reference Data


Configures Checks	HDB_Alerts
Default Value
Unit	String

HDBAlertsHighCountCrit

This monitoring parameter sets the HDB_Alerts check to critical, if the number of alerts with a rating High found within a timespan defined by by HDBAlertsTimeSpan is equal to or above the defined threshold.

note

Please note that no matter how this parameter is defined, the check status will at least be warning if at least one alert with high priority is found within HDBAlertsTimeSpan.

Reference Data


Configures Checks	HDB_Alerts
Default Value	1
Unit	Number

HDBAlertsLowCountWarn

This monitoring parameter sets the HDB_Alerts check to warning, if the number of alerts with a rating Low found within a timespan defined by by HDBAlertsTimeSpan is equal to or above the defined threshold.

note

HDB_Alerts will return a check status of OK if no alerts with priority above Low are found and if the number of Low priority alerts is below the threshold.

Reference Data


Configures Checks	HDB_Alerts
Default Value	20
Unit	Number

HDBAlertsMediumCountWarn

This monitoring parameter sets the HDB_Alerts check to warning, if the number of alerts with a rating Medium found within a timespan defined by by HDBAlertsTimeSpan is equal to or above the defined threshold.

note

HDB_Alerts will return a check status of OK if no alerts with priority above Medium are found and if the number of Low priority alerts is below the HDBAlertsLowCountWarn threshold.

Reference Data


Configures Checks	HDB_Alerts
Default Value	1
Unit	Number

HDBAlertsTimeSpan

Restricts the watch period of HDB_Alerts.

Reference Data


Configures Checks	HDB_Alerts
Default Value	60
Unit	Minutes

HDBBackupCompleteSelectRange

Restricts the watch period of HDB_Backup.

Reference Data


Configures Checks	HDB_Backup
Default Value	60
Unit	Days

HDBBackupPreparedWaitingOnSnapDelay

If the backup status is “prepared” and it started less than 5 Minutes earlier, then the check is OK.

Reference Data


Configures Checks	None
Default Value	5
Unit	Minutes

HDBCertificateValidityCrit

This monitoring parameter triggers the HDB_Certificates) check status to change to critical if the expiration date of a certificates is in less days, from now, than the defined value.

Reference Data


Configures Checks	HDB_Certificates
Default Value	5
Unit	Days

HDBCertificateValidityWarn

This monitoring parameter triggers the HDB_Certificates) check status to change to warning if the expiration date of a certificates is in less days, from now, than the defined value, but more than HDBCertificateValidityCrit.

Reference Data


Configures Checks	HDB_Certificates
Default Value	50
Unit	Days

HDBCertificateValidityIgnore

This monitoring parameter is used to define a time (day) value that once the age of an expired certificate is greater than the value, the certificate is ignored from the HDB_Certificates) check result.

Reference Data


Configures Checks	HDB_Certificates
Default Value	10
Unit	Days

HDBCertificatePurposes

This monitoring parameter configures HDB_Certificates to only monitor certificate collection purposes listed.

By default, this is set to empty and all purposes are considered.

Accepted list items are:

SSL
SAML
JWT
X509
SAP LOGON
DATABASE REPLICATION
LDAP
REMOTE SOURCE

Reference Data


Configures Checks	HDB_Certificates
Default Value
Unit	EnumX

HDBCertificateUsages

This monitoring parameter configures the HDB_Certificates) check to only monitor certificate usages listed.

By default, this is set to empty and will include all certificate usages.

Reference Data


Configures Checks	HDB_Certificates
Default Value
Unit	EnumX

HDBCPULoadAverageTime

Defines the time span (in minutes) that is taken into account for the HDB_CPULoad Check.

Reference Data


Configures Checks	HDB_CPULoad
Default Value	10
Unit	Minutes

HDBCPULoadCrit

If one of the node's CPU load exceeds this threshold, the check status turns to Critical.

Reference Data


Configures Checks	HDB_CPULoad
Default Value	90
Unit	%

HDBCPULoadWarn

If one of the node's CPU load exceeds this threshold, the check status turns to Warning, unless the Critical threshold HDBCPULoadCrit is exceeded for any node.

Reference Data


Configures Checks	HDB_CPULoad
Default Value	75
Unit	%

HDBDeltaMergesNumCrit

If there are more delta merges than the threshold taking longer than HDBDeltaMergesTimeCrit amount of time the check status of HDB_DeltaMerges turns to critical.

Reference Data


Configures Checks	HDB_DeltaMerges
Default Value	10
Unit	Number

HDBDeltaMergesNumWarn

If there are more delta merges than the threshold taking longer than HDBDeltaMergesTimeWarn amount of time the check status of HDB_DeltaMerges turns to warning, unless the critical threshold is exceeded.

Reference Data


Configures Checks	HDB_DeltaMerges
Default Value	5
Unit	Number

HDBDeltaMergesTimeCrit

If there are more delta merges than HDBDeltaMergesNumCrit taking longer than the defined amount of time the check status of HDB_DeltaMerges turns to critical.

Reference Data


Configures Checks	HDB_DeltaMerges
Default Value	20
Unit	Minutes

HDBDeltaMergesTimeWarn

If there are more delta merges than HDBDeltaMergesNumWarn taking longer than the defined amount of time the check status of HDB_DeltaMerges turns to warning, unless the critical threshold is exceeded.

Reference Data


Configures Checks	HDB_DeltaMerges
Default Value	10
Unit	Minutes

HDBDisksUsageCrit

f the usage of the disks containing the storage device exceeds the threshold the check status is set to Critical.

Reference Data


Configures Checks	HDB_Disks
Default Value	90 %
Unit	% or KB/MB/GB

HDBDisksUsageWarn

If the usage of the disks containing the storage device exceeds the threshold, the check status is set to Warning, unless the HDBDisksUsageCrit threshold is exceeded.

Reference Data


Configures Checks	HDB_Disks
Default Value	80 %
Unit	% or KB/MB/GB

HDBDisksLogExCrit

If the predicted point in time when the SAP HANA Log Area space is exceeded lies within the upcoming defined hours, the check status of HDB_DisksLog is set to Critical.

Reference Data


Configures Checks	HDB_DisksLog
Default Value	1
Unit	Hours

HDBDisksLogExWarn

If the predicted point in time when the SAP HANA Log Area space is exceeded lies within the upcoming defined hours, the check status of HDB_DisksLog is set to warning, unless the threshold for a critical status has been met.

Reference Data


Configures Checks	HDB_DisksLog
Default Value	12
Unit	Hours

HDBDisksLogUsageCrit

If the usage of the filesystems containing the log areas exceeds the threshold, the check status is set to Critical.

Reference Data


Configures Checks	HDB_DisksLog
Default Value	20 %
Unit	% or KB/MB/GB

HDBDisksLogUsageWarn

If the usage of the filesystems containing the log area exceeds the threshold, the check status is set to Warning, unless the HDBDisksLogUsageCrit threshold is exceeded.

Reference Data


Configures Checks	HDB_DisksLog
Default Value	10 %
Unit	% or KB/MB/GB

HDBDisksLogBackupUsageCrit

If the usage of the filesystems containing the log backups exceeds the threshold, the check status is set to Critical.

Reference Data


Configures Checks	HDB_DisksLogBackup
Default Value	85 %
Unit	% or KB/MB/GB

HDBDisksLogBackupUsageWarn

If the usage of the filesystems containing the log area exceeds the threshold, the check status is set to Warning, unless the HDBDisksLogBackupUsageCrit threshold is exceeded.

Reference Data


Configures Checks	HDB_DisksLogBackup
Default Value	70 %
Unit	% or KB/MB/GB

HDBExcludeStorageDeviceIDs

You can exclude storage devices from contributing to the check status by specifying the storage device ID using this parameter. Multiple entries must be separated by comma or semicolon. The syntax is forgiving, i. e. leading, trailing or multiple spaces will not harm and the right storage devices will still be excluded as long as numeric values are found.

note

Excluded storage devices will still be reported in the check result's overview table. They will be marked as Excluded Yes.

Reference Data


Configures Checks	HDB_Disks, HDB_DisksLogBackup, HDB_DisksLog
Default Value
Unit	String

HDBExcludeStorageIDs

You can exclude storage devices from contributing to the check status by specifying the storage ID using this parameter. Multiple entries must be separated by comma or semicolon. The syntax is forgiving, i. e. leading, trailing or multiple spaces will not harm and the right storage devices will still be excluded as long as numeric values are found.

note

Excluded storage devices will still be reported in the check result's overview table. They will be marked as Excluded Yes.

Reference Data


Configures Checks	HDB_Disks, HDB_DisksLogBackup, HDB_DisksLog
Default Value
Unit	String

HDBExcludeStorageTypes

You can exclude storage devices from contributing to the check status by specifying the storage device type (e.g. Data, Log_backup) using this parameter. Multiple entries must be separated by comma or semicolon. The exclude list may contain leading and/or trailing spaces, and spaces between the items. They will be trimmed away to make sure that the right storage devices will be excluded.

note

Excluded storage devices will still be reported in the check result's overview table. They will be marked as Excluded Yes.

Reference Data


Configures Checks	HDB_Disks, HDB_DisksLogBackup, HDB_DisksLog
Default Value
Unit	String

HDBExpSQLExclude

Programs executing SQL statements on this list are not considered for the check result. Wildcard * is allowed. Multiple entries must be separated by , (comma). If your statement includes a comma character, please escape it with a backslash \.

Reference Data


Configures Checks	HDB_ExpSQL
Default Value
Unit	String

HDBExpSQLTimePctCrit

If the total execution time of an SQL statement compared to the total execution time of all SQL statements exceeds the defined percent, the check status of HDB_ExpSQL turns to Critical.

Reference Data


Configures Checks	HDB_ExpSQL
Default Value	10
Unit	%

HDBExpSQLTimePctWarn

If the total execution time of an SQL statement compared to the total execution time of all SQL statements exceeds the defined percent the check status of HDB_ExpSQL turns to Warning, unless the Critical threshold is exceeded.

Reference Data


Configures Checks	HDB_ExpSQL
Default Value	5
Unit	%

HDBJobNameExclude

You can exclude job names from contributing to the check status by specifying the job names using this parameter. Multiple entries must be separated by comma or semicolon. The syntax is forgiving, i. e. leading, trailing or multiple spaces will not harm and the right jobs will still be excluded as long as the job name matches.

You may use placeholders ? (single character) and * (any number of characters) to specify a job name pattern to be excluded.

note

Excluded jobs will still be reported in the check result's overview table. They will be marked with an icon that shows an Excluded... tooltip text.

Reference Data


Configures Checks	HDB_JobRuntime
Default Value	Backup
Unit	String

HDBJobRuntimeCrit

If jobs are found running longer than the defined number of minutes the check status is set to Critical.

Reference Data


Configures Checks	HDB_JobRuntime
Default Value	10
Unit	Minutes

HDBJobRuntimeWarn

If jobs are found running longer than the defined number of minutes the check status is set to Warning, unless there is a job found running longer than HDBJobRuntimeCrit minutes.

Reference Data


Configures Checks	HDB_JobRuntime
Default Value	5
Unit	Minutes

HDBLandscapeSeverity

Define the severity of HDB_Landscape in case of a problem.

Reference Data


Configures Checks	HDB_Landscape
Default Value	Warning
Unit	Enum

HDBLicenseExpireTimeCrit

If the license has an expiration date, the Check HDB_License turns to Critical if less than the defined number of days are left until expiration.

Reference Data


Configures Checks	HDB_License
Default Value	7
Unit	Days

HDBLicenseExpireTimeWarn

If the license has an expiration date, the Check HDB_License turns to Warning if less than the defined number of days are left until expiration, unless the Critical threshold HDBLicenseExpireTimeCrit is exceeded.

Reference Data


Configures Checks	HDB_License
Default Value	30
Unit	Days

HDBLicenseMemoryConsumCrit

Memory relation of the used memory to the licensed memory.

Reference Data


Configures Checks	HDB_License
Default Value	90
Unit	%

HDBLicenseMemoryConsumWarn

Memory relation of the used memory to the licensed memory.

Reference Data


Configures Checks	HDB_License
Default Value	80
Unit	%

HDBLogBackupConsecutiveFailedThreshold

This monitoring parameter defines a threshold where if the number of consecutive failed log backups is higher than the threshold, the HDB_LogBackup check status is set to Critical.

Reference Data


Configures Checks	HDB_LogBackup
Default Value	1
Unit	Number

HDBLogBackupTimeSpan

Defines the time span in minutes which is used to examine log backups back from the current moment.

Reference Data


Configures Checks	HDB_LogBackup
Default Value	60
Unit	Number

HDBLogFilesCritCount

If more locked log files are found the HDB_LogFiles check status will change to critical.

Reference Data


Configures Checks	HDB_LogFiles
Default Value	5
Unit	Number

HDBLogFilesWarnCount

If more locked log files are found the HDB_LogFiles check status will change to warning.

Reference Data


Configures Checks	HDB_LogFiles
Default Value	3
Unit	Number

HDBMemoryPeakUsageCrit

If the Database peak memory usage compared to the allocation limit exceeds the defined threshold, the check status is set to Critical.

Reference Data


Configures Checks	HDB_MemoryPeak
Default Value	95 %
Unit	% or KB/MB/GB

HDBMemoryPeakUsageWarn

If the Database peak memory usage compared to the allocation limit exceeds the defined threshold, the check status is set to warning, unless the HDBMemoryPeakUsageCrit threshold has been met.

Reference Data


Configures Checks	HDB_MemoryPeak
Default Value	90 %
Unit	% or KB/MB/GB

HDBMemoryPhysicalUsageCrit

If a host's physical memory usage exceeds the defined threshold, the check status is set to Critical.

Reference Data


Configures Checks	HDB_MemoryPhysical
Default Value	95 %
Unit	% or KB/MB/GB

HDBMemoryPhysicalUsageWarn

If a host's physical memory usage exceeds the defined threshold, the check status is set to warning, unless the threshold for HDBMemoryPhysicalUsageCrit has been met.

Reference Data


Configures Checks	HDB_MemoryPhysical
Default Value	90 %
Unit	% or KB/MB/GB

HDBMemoryServicesUsageCrit

If a services memory usage exceeds a defined percent or a service's free memory falls below a defined number of KB/MB/GB, the check status is set to Critical.

Reference Data


Configures Checks	HDB_MemoryServices
Default Value	95 %
Unit	% or KB/MB/GB

HDBMemoryServicesUsageWarn

If a services memory usage exceeds a defined percent or a service's free memory falls below a defined number of KB/MB/GB, the check status is set to warning, unless the HDBMemoryServicesUsageCrit threshold is met.

Reference Data


Configures Checks	HDB_MemoryServices
Default Value	90 %
Unit	% or KB/MB/GB

HDBSystemReplDelayCrit

Configures the Critical threshold for system replication delay in seconds.

Reference Data


Configures Checks	HDB_SystemReplDelay
Default Value	3600
Unit	Seconds

HDBSystemReplDelayWarn

Configures the warning threshold for system replication delay in seconds.

Reference Data


Configures Checks	HDB_SystemReplDelay
Default Value	30
Unit	Seconds

HDBSystemReplIgnoreReplicationStatus

When set to True, this monitoring parameter configures HDB_SystemReplication to ignore the REPLICATION_STATUS column when considering the check status.

Reference Data


Configures Checks	HDB_SystemReplication
Default Value	False
Unit	Boolean

HDBSystemReplIgnoreSecondaryActive

When set to True, this monitoring parameter configures HDB_SystemReplication to ignore the SECONDARY_ACTIVE_STATUS column when considering the check status.

Reference Data


Configures Checks	HDB_SystemReplication
Default Value	True
Unit	Boolean

HDBSystemReplIgnoreSecondaryFullyRecoverable

When set to True, this monitoring parameter configures HDB_SystemReplication to ignore the SECONDARY_FULLY_RECOVERABLE column when considering the check status.

Reference Data


Configures Checks	HDB_SystemReplication
Default Value	False
Unit	Boolean

HDBSystemReplNotFoundStatus

If system replication is not set up for a HANA database, HDB_SystemReplication will return an OK check status by default. You can change this using the this parameter, thereby enforcing that system replication is configured.

Reference Data


Configures Checks	HDB_SystemReplication
Default Value	OK
Unit	Enum

HDBTableAllocationCrit

The relation of the total memory pools in % to the global allocation limit.

Reference Data


Configures Checks	HDB_TableAllocationUse
Default Value	50
Unit	%

HDBTableAllocationWarn

The relation of the total memory pools in % to the global allocation limit.

Reference Data


Configures Checks	HDB_TableAllocationUse
Default Value	30
Unit	%

HDBTableRowCountCrit

Value in relation to rows to the upper limit of 2 billion rows.

Reference Data


Configures Checks	HDB_TableRowCount
Default Value	90
Unit	%

HDBTableRowCountExclude

This parameter defines the tables, by name, that can be excluded from HDB_TableRowCount. Wildcards can be used.

Reference Data


Configures Checks	HDB_TableRowCount
Default Value
Unit	String

HDBTableRowCountTopTables

Define how many top tables the check monitors.

Reference Data


Configures Checks	HDB_TableRowCount
Default Value	10
Unit	Number

HDBTableRowCountWarn

Value in relation to rows to the upper limit of 2 billion rows.

Reference Data


Configures Checks	HDB_TableRowCount
Default Value	80
Unit	%

HDBTenantMemoryPeakUsageCrit

If the Database tenant peak memory usage compared to the allocation limit exceeds the threshold, the check status is set to Critical.

Reference Data


Configures Checks	HDB_TenantMemoryPeak
Default Value	95 %
Unit	% or KB/MB/GB

HDBTenantMemoryPeakUsageWarn

If the Database tenant peak memory usage compared to the allocation limit exceeds the threshold, the check status is set to warning, unless the HDBTenantMemoryPeakUsageCrit threshold has been met.

Reference Data


Configures Checks	HDB_TenantMemoryPeak
Default Value	90 %
Unit	% or KB/MB/GB

MSSBackupAgeMasterCrit

If the last successful backup of the MSSQL primary configuration Database is older than the defined number of days, the check status is set to Critical.

Reference Data


Configures Checks	MSS_DBBACKUP
Default Value	14
Unit	Days

MSSBackupAgeMasterWarn

If the last successful backup of the MSSQL primary configuration Database is older than the defined number of days, but not older than MSSBackupAgeMasterCrit days, the check status is set to Warning.

Reference Data


Configures Checks	MSS_DBBACKUP
Default Value	7
Unit	Days

MSSBackupAgeMsdbCrit

If the last successful backup of the MSSQL MSDB Database is older than the defined number of days, the check status is set to Critical.

Reference Data


Configures Checks	MSS_DBBACKUP
Default Value	14
Unit	Days

MSSBackupAgeMsdbWarn

If the last successful backup of the MSSQL MSDB Database is older than the defined number of days, but not older than MSSBackupAgeMsdbCrit days, the check status is set to Warning.

Reference Data


Configures Checks	MSS_DBBACKUP
Default Value	7
Unit	Days

MSSBackupExclude

Comma-separated list of database names that are ignored from the MSS_DBBACKUP check. By default, the check includes the master and msdb database as well. If you want to exclude databases, set the names of those databases in this monitoring parameter. Use a comma to separate multiple databases.

Reference Data


Configures Checks	None
Default Value
Unit	String

MSSDBExCrit

If the predicted point in time when the DB space limit is exceeded is within the upcoming defined number of hours, the check result of MSS_DBUSAGE is set to Critical.

Reference Data


Configures Checks	MSS_DBUSAGE
Default Value	1
Unit	Hours

MSSDBExWarn

If the predicted point in time when the DB space limit is exceeded is within the upcoming defined number of hours, but not within the upcoming MSSDBExCrit hours, the check result of MSS_DBUSAGE is set to Warning.

Reference Data


Configures Checks	MSS_DBUSAGE
Default Value	12
Unit	Hours

MSSDBForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	MSS_DBUSAGE
Default Value	Active
Unit	Enum

MSSDBUsageCrit

If the usage of the database exceeds the defined threshold, the check status is set to Critical.

Reference Data


Configures Checks	MSS_DBUSAGE
Default Value	95 %
Unit	% or KB/MB/GB

MSSDBUsageWarn

If the usage of the MSSQL database exceeds the defined threshold but does not exceed MSSDBUsageCrit threshold, the check status is set to Warning.

Reference Data


Configures Checks	MSS_DBUSAGE
Default Value	80 %
Unit	% or KB/MB/GB

MSSDBRemote

You can set this parameter if the monitoring Avantra Agent has no access to the filesystem holding the SQL Server installation, e.g. if you are using Agentless Monitoring.

In this case, the MSS_DBUSAGE and MSS_LOGUSAGE do not consider auto-growth database files.

Reference Data


Configures Checks	MSS_DBUSAGE, MSS_LOGUSAGE
Default Value	0
Unit	Boolean

MSSExpSQLExclude

SQL statements on this list are not considered for the check result. Wildcard * is allowed. Multiple entries must be separated by ; (semicolon). If your statement includes a semicolon character, please escape it with a backslash \.

Reference Data


Configures Checks	MSS_EXPSQL
Default Value	%_T*
Unit	String

MSSExpSQLExcludeShow

Defines whether or not excluded statements, which will not contribute to the check result, are displayed.

Reference Data


Configures Checks	MSS_EXPSQL
Default Value	0
Unit	Boolean

MSSExpSQLLogicalReadCrit

If for a particular SQL statement the amount of logical reads exceeds a defined percent of the total number of reads of all statements, the check turns to Critical.

Reference Data


Configures Checks	MSS_EXPSQL
Default Value	10
Unit	%

MSSExpSQLLogicalReadWarn

If for a particular SQL statement the amount of logical reads exceeds a defined percent of the total number of reads of all statements, but does not exceed MSSExpSQLLogicalReadCrit, the check turns to Warning.

Reference Data


Configures Checks	MSS_EXPSQL
Default Value	5
Unit	%

MSSExpSQLNumTopRecs

The number defined in this parameters limits the number of considered SQL statements to the top value. By default, the top 20000 SQL statements are shown. This is due to performance reasons.

Reference Data


Configures Checks	MSS_EXPSQL
Default Value	2000
Unit	Number

MSSExpSQLPhysicalReadCrit

If for a particular SQL statement the amount of physical reads exceeds a defined percent of the total number of reads of all statements, the check turns to Critical.

Reference Data


Configures Checks	MSS_EXPSQL
Default Value	10
Unit	%

MSSExpSQLPhysicalReadWarn

If for a particular SQL statement the amount of physical reads exceed a defined percent of the total number of reads of all statements, but does not exceed MSSExpSQLPhysicalReadCrit, the check turns to Warning.

Reference Data


Configures Checks	MSS_EXPSQL
Default Value	5
Unit	%

MSSLogBckAgeCrit

If the transaction log for the MSSQL database is older than the defined number of minutes, the check status is set to Critical.

Reference Data


Configures Checks	MSS_LOGBACKUP
Default Value	60
Unit	Minutes

MSSLogBckAgeWarn

If the transaction log for the SAP SID database is older than the defined number of minutes, but is not older than MSSLogBckAgeCrit minutes, the check status is set to Warning.

Reference Data


Configures Checks	MSS_LOGBACKUP
Default Value	30
Unit	Minutes

MSSLogExCrit

If the predicted point in time when the transaction log limit is exceeded is within the upcoming defined number of hours, the check status is set to Critical.

Reference Data


Configures Checks	MSS_LOGUSAGE
Default Value	1
Unit	Hours

MSSLogExWarn

If the predicted point in time when the transaction log limit is exceeded is within the upcoming defined number of hours, the check status is set to Warning, unless the MSSLogExCrit threshold is exceeded.

Reference Data


Configures Checks	MSS_LOGUSAGE
Default Value	12
Unit	Hours

MSSLogForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	MSS_LOGUSAGE
Default Value	Active
Unit	Enum

MSSLogUsageCrit

If the usage of the transaction log of the database exceeds the threshold, the check status is set to Critical.

Reference Data


Configures Checks	MSS_LOGUSAGE
Default Value	95 %
Unit	% or KB/MB/GB

MSSLogUsageWarn

If the usage of the transaction log of the database exceeds the threshold, the check status is set to Warning, unless the MSSLogUsageCrit threshold is exceeded.

Reference Data


Configures Checks	MSS_LOGUSAGE
Default Value	80 %
Unit	% or KB/MB/GB

MSSUseNTLMv2

A recent version of the Microsoft SQL server might force SQL connections to use NT LAN Manager Protocol Version 2 (NTLMv2) security. If you experience the error message The login is from an untrusted domain and cannot be used with Windows authentication in the DBCONNECT check, setting this parameter to true might fix this.

Reference Data


Configures Checks	None
Default Value	0
Unit	Boolean

ORAAlertLogCountCrit

The check status will be Critical if that many log entries considered as critical are found.

Reference Data


Configures Checks	ORA_ALERTLOG
Default Value	1
Unit	Number

ORAAlertLogCountWarn

The check status will be Warning if that many log entries considered as Warning are found, unless the ORAAlertLogCountCrit threshold is exceeded.

Reference Data


Configures Checks	ORA_ALERTLOG
Default Value	1
Unit	Number

ORAAlertLogExprCrit

Designates an entry in the Oracle alert log as critical. Readers familiar with regular expressions may note that the expression below is a Perl style regular expression which is case insensitive.


Configures Checks	ORA_ALERTLOG
Default Value	`'%%msg%% =~ /ORA-0*(?:(255\|257\|270\|272\|376\|447\|470\|471\|472\|473\|474\|600\|603\|1113\|1114\|1115\|1122\|1135\|1578\|1628\|1629\|1630\|1631\|1632\|1650\|1651\|1652\|1653\|1654\|1655\|1656\|1680\|1681\|1683\|1684\|1685\|1688\|1691\|1692\|1693\|1694\|3113\|7445\|16014\|16038\|19502\|19504\|19510\|27044\|27063\|27072\|30036)(?:\D\|$))\|Corrupt block/i and not Like('%%msg%%';'Patch Description:')`
Unit	Expression

ORAAlertLogExprWarn

Designates an entry in the Oracle alert log as warning.


Configures Checks	ORA_ALERTLOG
Default Value	`'%%msg%%' =~ /ORA-0*(?:(60\|1149\|1555\|1562)(?:\D\|$))\|Checkpoint not complete/i and not Like('%%msg%%';'Patch Description:')`
Unit	Expression

ORAAlertLogLocation

Defines the location of the Oracle alert log file (full path, including the file name). The macro %%SID%% is provided and will be replaced with the Real SAP SID (for SAP Systems) or the database name (for Databases). The macro %%ORACLE_HOME%% may be used as well.

Reference Data


Configures Checks	None
Default Value
Unit	String

ORAAlertLogTimeSpan

Restricts the watch period of the ORA_ALERTLOG check.

Reference Data


Configures Checks	ORA_ALERTLOG
Default Value	60
Unit	Minutes

ORABackupSkipFilesCheck

If the flag is set, the ORA_BACKUP does not verify if files marked as active in RMAN do actually exist on the filesystem.

Reference Data


Configures Checks	ORA_BACKUP
Default Value	0
Unit	Boolean

ORABackupTool

This parameter tells Avantra which backup tool is used for the backup of the Oracle Database and thus controls which checks are executed.

If the parameter is set to RMAN the check ORA_BACKUP is executed which verifies backups performed with Oracle RMAN. If the parameter is set to BRBACKUP, the checks ORA_BRBACKUPSTAT, ORA_BRBACKUP, and ORA_BRARCHIVE will be executed.

Reference Data


Configures Checks	ORA_BACKUP, ORA_BRBACKUPSTAT, ORA_BRBACKUP, ORA_BRARCHIVE
Default Value
Unit	Enum

ORABrbackupDelayCrit

If the running time of an Oracle online backup is above the defined percent of the usual average runtime, the check status is set to Critical.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT
Default Value	100
Unit	%

ORABrbackupDelayTimeCrit

If the running time of an Oracle online backup is above ORABrbackupDelayCrit percent of the usual average runtime and above the defined number of minutes in this parameter, the check status is set to Critical.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT
Default Value	30
Unit	Minutes

ORABrbackupDelayTimeWarn

If the running time of an Oracle online backup is above ORABrbackupDelayWarn percent of the usual average runtime and above ORABrbackupDelayTimeWarn minutes, but below ORABrbackupDelayCrit percent or ORABrbackupDelayTimeCrit minutes, the check status is set to Warning.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT
Default Value	15
Unit	Minutes

ORABrbackupDelayWarn

If the running time of an Oracle online backup is above ORABrbackupDelayWarn percent of the usual average runtime, but below ORABrbackupDelayCrit percent, the check status is set to Warning.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT
Default Value	50
Unit	%

ORABrbackupOfflineDelayCrit

If the running time of an Oracle offline backup is above ORABrbackupOfflineDelayCrit percent of the usual average runtime, the check status of the DBCONNECT, RFCCONNECT or J2EECONNECT checks are set to Critical. For standalone Oracle Databases, the parameter is only effective if the BR*Tools are used.

Reference Data


Configures Checks	RFCCONNECT, DBCONNECT
Default Value	50
Unit	%

ORABrbackupSuccessFIDs

Defines the BRBACKUP function IDs considered as valid backup types when BRBACKUP is checked. The pre-configured ant aft means only full tape backups are considered as backups. If your Oracle database is backed up with backint (and thus the backup target is a file instead of a tape), you need to set the parameter to ant aft anf aff.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT, ORA_BRBACKUP
Default Value	ant aft
Unit	String

ORABrToolsSchema

This parameter defines the Oracle schema where the tables for BR*Tools are located. Usually, the Avantra Agent determines the schema, and only if this fails you need to define the schema manually.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT, ORA_BRBACKUP, ORA_BRARCHIVE
Default Value
Unit	String

ORABrToolsSelectRange

Only the latest ORABrToolsSelectRange days are searched for successful BR*Tools operations.

Reference Data


Configures Checks	ORA_BRBACKUPSTAT, ORA_DBCHECKLOG, ORA_BRBACKUP, ORA_BRARCHIVE
Default Value	90
Unit	Days

ORADataFileIncrementsCrit

Controls the number of auto-extent increments to be available in an Oracle datafile filesystem before a Critical alert is raised.

Reference Data


Configures Checks	ORA_DATAFILES
Default Value	0
Unit	Number

ORADataFileIncrementsWarn

Controls the number of auto-extent increments to be available in an Oracle datafile filesystem before a Warning alert is raised.

Reference Data


Configures Checks	ORA_DATAFILES
Default Value	2
Unit	Number

ORADataGuardDBCount

Defines the number of databases to be monitored by ORA_DATAGUARD check. To enable the check, set the ORADataGuardDBCount value to 1.

Reference Data


Configures Checks	ORA_DATAGUARD
Default Value	0
Unit	Number

ORADBAOperAgeCrit

If the last successful execution of any of the checked DBA operations is older than ORADBAOperAgeCrit days, the check status turns to Critical.

Reference Data


Configures Checks	ORA_DBAOPER
Default Value	14
Unit	Days

ORADBAOperAgeWarn

If the last successful execution of any of the checked DBA operations is older than ORADBAOperAgeWarn days, but none is older than ORADBAOperAgeCrit or even unsuccessful, the check status turns to Warning.

Reference Data


Configures Checks	ORA_DBAOPER
Default Value	7
Unit	Days

ORADBAOperFunctionIDs

Only the DBA operations corresponding to the function IDs defined with this parameter are considered by the ORA_DBAOPER check.

Reference Data


Configures Checks	ORA_DBAOPER
Default Value	aly dbv opt
Unit	String

ORADBAOperSelectRange

Only the latest ORADBAOperSelectRange days are searched for successful DBA operations.

Reference Data


Configures Checks	ORA_DBAOPER
Default Value	60
Unit	Days

ORADBRemote

You may set this parameter if the monitoring Avantra Agent has no access to the filesystem holding the Oracle installation, e.g. if you are using Agentless Monitoring.

Reference Data


Configures Checks	RFCCONNECT, ORA_BACKUP, ORA_FSLOGARCH, ORA_DATAFILES, ORA_ALERTLOG
Default Value	0
Unit	Boolean

ORAEnqueueDeadLocksCrit

This parameter defines the minimum number of deadlocks that must have occurred in the last ORAEnqueueTimeSpan minutes to turn the ORA_Enqueue check Critical.

By setting this parameter to -1, the deadlocks check of ORA_Enqueue is disabled.

Reference Data


Configures Checks	ORA_Enqueue
Default Value	1
Unit	Number

ORAEnqueueDeadLocksWarn

his parameter defines the minimum number of deadlocks that must have occurred in the last ORAEnqueueTimeSpan minutes to turn the ORA_Enqueue check Warning.

If this parameter is set to a value equal to or higher than ORAEnqueueDeadLocksCrit, it has no effect.

Reference Data


Configures Checks	ORA_Enqueue
Default Value	1
Unit	Number

ORAEnqueueTimeoutsCrit

This parameter defines the minimum ratio of timeouts to requests/conversions of the last ORAEnqueueTimeSpan minutes necessary to turn the ORA_Enqueue check Critical.

By setting this parameter to 0, the timeouts check of ORA_Enqueue is disabled.

Reference Data


Configures Checks	ORA_Enqueue
Default Value	20
Unit	%

ORAEnqueueTimeoutsWarn

This parameter defines the minimum ratio of timeouts to requests/conversions of the last ORAEnqueueTimeSpan minutes necessary to turn the ORA_Enqueue check Warning.

If this parameter is set to a value equal to or higher than ORAEnqueueTimeoutsCrit, it has no effect.

Reference Data


Configures Checks	ORA_Enqueue
Default Value	10
Unit	%

ORAEnqueueTimeSpan

The ORA_Enqueue check collects enqueue statistics data up to a certain age. This parameter defines the age (in minutes) of the oldest data set to consider. If a data set gets older, it's removed from the collection.

Reference Data


Configures Checks	ORA_Enqueue
Default Value	30
Unit	Minutes

ORAEnqueueWaitsCrit

This parameter defines the minimum ratio of wait events to requests/conversions of the last ORAEnqueueTimeSpan minutes necessary to turn the ORA_Enqueue check Critical.

By setting this parameter to 0, the wait events check part of ORA_Enqueue is disabled.

Reference Data


Configures Checks	ORA_Enqueue
Default Value	75
Unit	%

ORAEnqueueWaitsWarn

This parameter defines the minimum ratio of wait events to requests/conversions of the last ORAEnqueueTimeSpan minutes necessary to turn the ORA_Enqueue check Warning.

If this parameter is set to a value equal to or higher than ORAEnqueueWaitsCrit, it has no effect.

Reference Data


Configures Checks	ORA_Enqueue
Default Value	50
Unit	%

ORAExpSQLExclude

Statements issued from programs listed within this parameter are not considered for the check result. The list is separated by one or more blank spaces. Program names containing blank spaces must be enclosed in double quotes. You may use the special macro <NOPROG> to sort out statements that have no Program Name value.

Note that prior to SAP Basis Release 4.5C no program names are shown at all. In this case, the <NOPROG> macro excludes all statements.

Reference Data


Configures Checks	ORA_EXPSQL
Default Value	%_T*
Unit	String

ORAExpSQLExcludeShow

Defines whether or not statements generated by excluded programs are shown in the check message.

Reference Data


Configures Checks	ORA_EXPSQL
Default Value	0
Unit	Boolean

ORAExpSQLGetCrit

If any SQL statement (not excluded by ORAExpSQLExclude) exceeds an amount of ORAExpSQLGetCrit percent of the total buffer gets, the check result turns to Critical.

Reference Data


Configures Checks	ORA_EXPSQL
Default Value	10
Unit	%

ORAExpSQLGetWarn

If any SQL statement (not excluded by ORAExpSQLExclude) exceeds an amount of ORAExpSQLGetWarn percent of the total buffer gets, and no statement exceeds an amount of ORAExpSQLGetCrit percent of the total buffer gets or ORAExpSQLReadCrit percent of the total disk reads, the check turns to Warning.

Reference Data


Configures Checks	ORA_EXPSQL
Default Value	5
Unit	%

ORAExpSQLReadCrit

If any SQL statement (not excluded by ORAExpSQLExclude) exceeds an amount of ORAExpSQLReadCrit percent of the total disk reads, the check result turns to Critical.

Reference Data


Configures Checks	ORA_EXPSQL
Default Value	10
Unit	%

ORAExpSQLReadWarn

If any SQL statement (not excluded by ORAExpSQLExclude) exceeds an amount of ORAExpSQLReadWarn percent of the total disk reads, and no statement exceeds an amount of ORAExpSQLGetCrit percent of the total buffer gets or ORAExpSQLReadCrit percent of the total disk reads, the check turns to Warning.

Reference Data


Configures Checks	ORA_EXPSQL
Default Value	5
Unit	%

ORAExtentsUsageCrit

If the number of extents allocated for an Oracle segment exceeds ORAExtentsUsageCrit percent of max_extents defined for this segment, the check status is set to Critical.

Reference Data


Configures Checks	ORA_SEGMENTS
Default Value	95
Unit	%

ORAExtentsUsageWarn

If the number of extents allocated for an Oracle segment exceeds a percentage of max_extents defined for this segment, but does not exceed ORAExtentsUsageCrit percent, the check status is set to Warning.

Reference Data


Configures Checks	ORA_SEGMENTS
Default Value	90
Unit	%

ORAFSLogArchCrit

If the log arch filesystem usage exceeds the defined threshold, the check status is set to Critical. The log arch filesystem is discovered automatically by Avantra Agent.

Reference Data


Configures Checks	ORA_FSLOGARCH
Default Value	85 %
Unit	% or KB/MB/GB

ORAFSLogArchWarn

If the log arch filesystem usage exceeds the ORAFSLogArchWarn threshold, but does not exceed the ORAFSLogArchCrit threshold, the check status is set to Warning, unless the ORAFSLogArchExCrit threshold is exceeded.

Reference Data


Configures Checks	ORA_FSLOGARCH
Default Value	70 %
Unit	% or KB/MB/GB

ORAFSLogArchExCrit

If the predicted point in time when the filesystem limit is exceeded is within the upcoming defined number of hours, the check result is set to Critical.

Reference Data


Configures Checks	ORA_FSLOGARCH
Default Value	1
Unit	Hours

ORAFSLogArchExWarn

If the predicted point in time when the filesystem limit is exceeded is within the upcoming defined number of hours, but not within the upcoming ORAFSLogArchExCrit hours, the check result is set to Warning, unless the ORAFSLogArchExCrit threshold is exceeded.

Reference Data


Configures Checks	ORA_FSLOGARCH
Default Value	12
Unit	Hours

ORAFSLogArchForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	ORA_FSLOGARCH
Default Value	Active
Unit	Enum

ORAFSLogArchLocation

The ORA_FSLOGARCH check tries to read the log archive destination location from the Oracle parameters. In cases where this doesn't work, this parameter allows you to force override / set the archive destination location. There can be multiple paths entered, separated by semicolons ( ';' ).

Reference Data


Configures Checks	ORA_FSLOGARCH
Default Value
Unit	String

ORAHomeDir

Usually, the Avantra Agent determines the Oracle Home directory automatically. In case it does not you may set this parameter accordingly.

Reference Data


Configures Checks	DBCONNECT, ORA_BACKUP, ORA_TABLESPACES, ORA_SEGMENTS, ORA_FSLOGARCH, ORA_LOG_MODE, ORA_DATAFILES, ORA_ALERTLOG, ORA_BRBACKUPSTAT, ORA_EXPSQL, ORA_DBAOPER, ORA_DBCHECKLOG, ORA_BRBACKUP, ORA_BRARCHIVE
Default Value
Unit	String

ORARMANSelectRange

ORA_BACKUP will select RMAN data not older than defined in this parameter.

Reference Data


Configures Checks	ORA_BACKUP
Default Value	30
Unit	Days

ORASAPToolsEnable

If the parameter is set, the checks ORA_DBAOPER and ORA_DBCHECKLOG will be executed.

This is the default for Database instances of an SAP System.

If you run SAPDBA or BRCONNECT with a standalone Database you may set this parameter as well.

Reference Data


Configures Checks	ORA_DBAOPER, ORA_DBCHECKLOG
Default Value
Unit	Boolean

ORASAPToolsSchema

This parameter defines the Oracle schema where the tables for SAPDBA or BRCONNECT are located. Usually, Avantra Agent determines the schema and only if this fails, you need to define the schema manually.

Reference Data


Configures Checks	ORA_DBAOPER, ORA_DBCHECKLOG
Default Value
Unit	String

ORASegsChkWaitTime

Defines the time interval between two ORA_SEGMENTS checks.

Reference Data


Configures Checks	ORA_SEGMENTS
Default Value	60
Unit	Minutes

ORASessionsCountWait

Defines the count threshold for sessions that exceed ORASessionsTimeWaitWarn or ORASessionsTimeWaitCrit time thresholds. The threshold is compared to the number of Critical sessions for a Critical check result, or the number of Critical plus Warning sessions for a Warning check result.

Reference Data


Configures Checks	ORA_Sessions
Default Value	1
Unit	Number

ORASessionsIgnoreWaitClass

Configures the wait classes that shall be ignored by ORA_Sessions.

Reference Data


Configures Checks	ORA_Sessions
Default Value	Idle Configuration Concurrency
Unit	String

ORASessionsTimeWaitCrit

ORA_Sessions compares session wait times of matching sessions against this threshold to categorize them as Critical. All Critical sessions are counted and further compared against ORASessionsCountWait for the final check result.

Reference Data


Configures Checks	ORA_Sessions
Default Value	10
Unit	Minutes

ORASessionsTimeWaitWarn

ORA_Sessions compares session wait times of matching sessions against this threshold to categorize them as Warning. All Warning sessions are counted and further compared against ORASessionsCountWait for the final check result.

Reference Data


Configures Checks	ORA_Sessions
Default Value	5
Unit	Minutes

ORATableSpaceExCrit

If the predicted point in time when the tablespace limit is exceeded is within the upcoming defined number of hours, the check result of ORA_TABLESPACES is set to Critical.

Reference Data


Configures Checks	ORA_TABLESPACES
Default Value	1
Unit	Hours

ORATableSpaceExWarn

If the predicted point in time when the tablespace limit is exceeded is within the upcoming ORATableSpaceExWarn hours, but not within the upcoming defined number of hours, the check result of ORA_TABLESPACES is set to Warning, unless the ORATableSpaceUsageCrit threshold is exceeded for some tablespace.

Reference Data


Configures Checks	ORA_TABLESPACES
Default Value	12
Unit	Hours

ORATableSpaceForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	ORA_TABLESPACES
Default Value	Active
Unit	Enum

ORATableSpaceUsageCrit

If one of the databases tablespaces usage exceeds the defined threshold, the check status is set to Critical.

Reference Data


Configures Checks	ORA_TABLESPACES
Default Value	98 %
Unit	% or KB/MB/GB

ORATableSpaceUsageWarn

If one of the databases tablespaces usage exceeds the defined threshold, the check status is set to Warning, unless the ORATableSpaceExCrit threshold is exceeded for some tablespace.

Reference Data


Configures Checks	ORA_TABLESPACES
Default Value	95 %
Unit	% or KB/MB/GB

ORATableSpaceUseSegments

When set to True, this monitoring parameter enables the use of segment-based usage data in SQL Statements.

Reference Data


Configures Checks	ORA_TABLESPACES
Default Value	0
Unit	Boolean

ORATNSAdminDir

By default, Avantra uses TNS to connect the Oracle database of an SAP System. Thus the Avantra Agent will determine the TNS admin directory (where the file tnsnames.ora is located). If this process fails, e.g. since the Oracle home directory could not be determined, you may set ORATNSAdminDir manually to work around the issue.

Reference Data


Configures Checks	DBCONNECT
Default Value
Unit	String

ORATNSAlias

By default, Avantra uses TNS to connect the Oracle Database instance of an SAP System with the TNS alias being equal to the Real SAP SID. If the TNS alias is different from the Real SAP SID, you need to set this parameter to the corresponding TNS alias.

Reference Data


Configures Checks	DBCONNECT
Default Value
Unit	String

PerfDataCollection

Controls whether or not Performance Data Collection is turned on for Systems. If you do not want the Avantra Agent to collect performance data you may remove the flag.

Reference Data


Configures Checks	None
Default Value	1
Unit	Boolean

PGSQLBloatIndexPctCrit

This monitoring parameter defines the critical threshold for the index bloat percentage in PostgreSQL Database. If an index exceeds the value of preset bloat percentage of the DB size, the check result is Critical.

Reference Data


Configures Checks	PGSQL_Bloat
Default Value	25
Unit	Percent

PGSQLBloatIndexPctWarn

This monitoring parameter defines if the index bloat percentage in PostgreSQL Database is higher than the predefined parameter value and not higher than the PGSQLBloatIndexPctCrit value. If the index bloat percentage is within these limits, then the check result is Warning.

Reference Data


Configures Checks	PGSQL_Bloat
Default Value	2.5
Unit	Percent

PGSQLBloatTablePctCrit

This monitoring parameter defines the threshold for the table bloat percentage in PostgreSQL Database. If a table exceeds the value of preset bloat percentage of the Database size, the check result is Critical.

Reference Data


Configures Checks	PGSQL_Bloat
Default Value	90
Unit	Percent

PGSQLBloatTablePctWarn

This monitoring parameter defines if the table bloat percentage in PostgreSQL Database is higher than the preset parameter value and not higher than the PGSQLBloatTablePctCrit parameter value. If the value of bloat percentage is within these limits, then the check result is Warning.

Reference Data


Configures Checks	PGSQL_Bloat
Default Value	5
Unit	Percent

PGSQLConnectionsUsedCrit

This monitoring parameter defines the threshold for the ratio of active user connections to the total number of connections in PostgreSQL Database. If this ratio exceeds the preset value, the check result is Critical.

Reference Data


Configures Checks	PGSQL_Connections
Default Value	90
Unit	Percent

PGSQLConnectionsUsedWarn

This monitoring parameter defines if the ratio of active user connections to the total number of connections in PostgreSQL Database exceeds the parameter value and not above the PGSQLConnectionsUsedCrit parameter value. If the percentage of active user connections is within these limits, then the check result is Warning.

Reference Data


Configures Checks	PGSQL_Connections
Default Value	80
Unit	Percent

PGSQLDeadlocksCrit

This monitoring parameter defines the critical threshold for the number of deadlocks detected per hour in PostgreSQL. If the number goes above this parameter value, the check result is Critical.

Reference Data


Configures Checks	PGSQL_Deadlocks
Default Value	600
Unit	Number

PGSQLDeadlocksWarn

This monitoring parameter defines if the number of deadlocks detected per hour in PostgreSQL is higher than the parameter value (preset by customer) and not higher than the PGSQLDeadlocksCrit parameter value. If the number returned is within these limits, then the check result is Warning.

Reference Data


Configures Checks	PGSQL_Deadlocks
Default Value	60
Unit	Number

PGSQLIdleInTransactionsCrit

This monitoring parameter defines the Critical threshold if the number of idle in transaction sessions in PostgreSQL Database reaches the defined threshold.

Reference Data


Configures Checks	PGSQL_LongTransactions
Default Value	5
Unit	Number

PGSQLIdleInTransactionsWarn

This monitoring parameter defines the Warning threshold if the number of idle in transaction sessions in PostgreSQL Database reaches the defined threshold.

Reference Data


Configures Checks	PGSQL_LongTransactions
Default Value	1
Unit	Number

PGSQLLongTransactionsCrit

This monitoring parameter defines the Critical threshold if the number of long-running sessions in PostgreSQL Database reaches the defined threshold.

Reference Data


Configures Checks	PGSQL_LongTransactions
Default Value	10
Unit	Number

PGSQLLongTransactionsWarn

This monitoring parameter defines the Warning threshold if the number of long-running sessions in PostgreSQL Database reaches the defined threshold.

Reference Data


Configures Checks	PGSQL_LongTransactions
Default Value	1
Unit	Number

PGSQLReplicationSlotLagCrit

This monitoring parameter defines the threshold for replication slot lag in PostgreSQL Database. If the lag goes above or equals this parameter value, the check result is Critical.

Reference Data


Configures Checks	PGSQL_ReplicationSlot
Default Value	16
Unit	Number

PGSQLReplicationSlotLagWarn

This monitoring parameter defines the threshold for replication slot lag in PostgreSQL Database. If the lag goes above or equals this parameter value, the check result is Warning.

Reference Data


Configures Checks	PGSQL_ReplicationSlot
Default Value	1
Unit	Number

PGSQLTempFileCrit

This monitoring parameter defines the threshold for the number of files in the temporary files storage in PostgreSQL Database. If this number exceeds the parameter value, the check result is Critical.

Reference Data


Configures Checks	PGSQL_TempFiles
Default Value	600
Unit	Number

PGSQLTempFileWarn

This monitoring parameter defines the threshold for the number of files in the temporary files storage in PostgreSQL Database. If this number exceeds the parameter value, the check result is Warning.

Reference Data


Configures Checks	PGSQL_TempFiles
Default Value	60
Unit	Number

PGSQLTransactionIdletime

This monitoring parameter defines the length of time that a transaction needs to run before it's considered as an idle in transaction.

Reference Data


Configures Checks	PGSQL_LongTransactions
Default Value	300
Unit	Number

PGSQLTransactionRuntime

This monitoring parameter defines the length of time that a transaction needs to run for before it's considered a long-running transaction.

Reference Data


Configures Checks	PGSQL_LongTransactions
Default Value	600
Unit	Number

PredictiveAnalyticsEngine

Use this monitoring parameter to configure the Predictive Analytics engine for the Database. By default the engine is configured as Balanced.

Available options are:

Use Off to turn off the Predictive Analytics engine.
Use Best Performance to configure the Predictive Analytics engine to run with best performance.
Use Balanced to configure the Predictive Analytics engine to run in a balanced way.
Use Highest Precision to configure the Predictive Analytics engine to run with highest precision.

Reference Data


Configures Checks	None
Default Value	Balanced
Unit	Enum

RelevantDailyCheckDetails

Defines a list of Daily Check details that are considered relevant for the Daily Check status, i.e. the status of which contributes to the overall status. By default the parameter is not defined, i.e. all Daily Check details contribute.

If you define an empty list no Daily Check detail will contribute. In this case, the status of the Daily Check will be Unknown always.

Reference Data


Configures Checks	None
Default Value
Unit	DCDList

RunDailyCheckOnWE

If set, Daily Checks will run on Saturday and Sunday as well.

Reference Data


Configures Checks	SYB_ErrorLog, FULLCHECK
Default Value	0
Unit	Boolean

RUNJSAllowDBWrite

This monitoring parameters can be set to 'Enabled' or 'Disabled' (default) value. It allows SQL queries defined within custom checks and workflows to change the data in the Database.

note

This monitoring parameter is only effective when the configuration setting Security.RUNJSAllowDBWrite is set to moniparam.

Reference Data


Configures Checks	None
Default Value	Disabled
Unit	Enum

SIQBackupSelectRange

SIQ_Backup looks back the defined number of days to find successful backups. The default value is 60 days, so usually, there is no need to change this parameter since backups must be made far more often.

Reference Data


Configures Checks	SIQ_Backup
Default Value	60
Unit	Days

SIQCatalogCacheUsageCrit

If the Catalog cache usage goes above this parameter value, the check result is Critical.

Reference Data


Configures Checks	SIQ_Cache
Default Value	95
Unit	%

SIQCatalogCacheUsageWarn

If the Catalog cache usage goes above this parameter value, the check result is Warning.

Reference Data


Configures Checks	SIQ_Cache
Default Value	80
Unit	%

SIQConnectionsNumCrit

If the number of free connections goes below this parameter value, the check result is Critical.

Reference Data


Configures Checks	SIQ_Connections
Default Value	2
Unit	Number

SIQConnectionsNumWarn

If the number of free connections goes below this parameter value and not below SIQConnectionsNumCrit parameter value, the check result is Warning.

Reference Data


Configures Checks	SIQ_Connections
Default Value	5
Unit	Number

SIQDataFilesUsageCrit

If the dbfile usage exceeds the defined threshold the check status is set to Critical.

Reference Data


Configures Checks	SIQ_DataFiles
Default Value	95 %
Unit	% or KB/MB/GB

SIQDataFilesUsageWarn

If the dbfile usage of a database exceeds the defined threshold the check status is set to Warning.

Reference Data


Configures Checks	SIQ_DataFiles
Default Value	80 %
Unit	% or KB/MB/GB

SIQDataSpacesExCrit

If the predicted point in time when the dataspace is exceeded is within the upcoming defined number of hours, the check status of SIQ_DataSpaces is set to Critical.

Reference Data


Configures Checks	SIQ_DataSpaces
Default Value	1
Unit	Hours

SIQDataSpacesExWarn

If the predicted point in time when the data space is exceeded is within the upcoming defined number of hours, but not within the upcoming SIQDataSpacesExCrit hours, the check status of SIQ_DataSpaces is set to Warning.

Reference Data


Configures Checks	SIQ_DataSpaces
Default Value	12
Unit	Hours

SIQDataSpacesForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	SIQ_DataSpaces
Default Value	Active
Unit	Enum

SIQDataSpacesUsageCrit

If the usage of a dataspace exceeds the threshold the check status is set to Critical.

Reference Data


Configures Checks	SIQ_DataSpaces
Default Value	95 %
Unit	% or KB/MB/GB

SIQDataSpacesUsageWarn

If the usage of a dataspace exceeds the threshold the check status is set to Warning, unless the SIQDataSpacesUsageCrit threshold is exceeded.

Reference Data


Configures Checks	SIQ_DataSpaces
Default Value	80 %
Unit	% or KB/MB/GB

SIQLongTransactionsWarn

Configures a warning threshold for the number of long-running transactions. If the number goes above or equals this parameter value, but does not reach the SIQOperationsWaitingCrit parameter, the check result is Warning.

Reference Data


Configures Checks	SIQ_LongTransactions
Default Value	1
Unit	Number

SIQLongTransactionsCrit

Configures a critical threshold for the number of long-running transactions. If the number exceeds or equals this parameter value, the check result is Critical.

Reference Data


Configures Checks	SIQ_LongTransactions
Default Value	5
Unit	Number

SIQMainCacheUsageCrit

If the Main cache usage goes below this parameter value, the check result is Critical. By default this parameter is disabled (-1%).

Reference Data


Configures Checks	SIQ_Cache
Default Value	-1
Unit	%

SIQMainCacheUsageWarn

If the Main cache usage is equal or less than the defined value the check result is Warning.

Reference Data


Configures Checks	SIQ_Cache
Default Value	80
Unit	%

SIQOperationsWaitingCrit

If the number of waiting operations goes above this parameter value, the check result is Critical.

Reference Data


Configures Checks	SIQ_OperationsWaiting
Default Value	10
Unit	Number

SIQOperationsWaitingWarn

If the number of waiting operations goes above this parameter value and below the SIQOperationsWaitingCrit parameter value, the check result is Warning.

Reference Data


Configures Checks	SIQ_OperationsWaiting
Default Value	5
Unit	Number

SIQTempCacheUsageCrit

If the Temp cache usage is equal or higher than this parameter value, the check result is Critical.

Reference Data


Configures Checks	SIQ_Cache
Default Value	95
Unit	%

SIQTempCacheUsageWarn

If the Temp cache usage is equal or higher than this parameter value and below SIQTempCacheUsageCrit, the check result is Warning.

Reference Data


Configures Checks	SIQ_Cache
Default Value	90
Unit	%

SIQThreadsWarn

If the number of free threads goes below this parameter value and not below the SIQThreadsCrit parameter value, the check result is Warning.

Reference Data


Configures Checks	SIQ_Threads
Default Value	20
Unit	Number

SIQThreadsCrit

If the number of free threads goes below or equals this parameter value, the check result is Critical.

Reference Data


Configures Checks	SIQ_Threads
Default Value	5
Unit	Number

SIQTransactionRuntime

Configures the time a transaction may run without being treated as long-running. If some transaction is running longer than the defined value.

Reference Data


Configures Checks	SIQ_LongTransactions
Default Value	60
Unit	Minutes

StartStopDependentWINService

This parameter is only applicable if your database runs on a Windows operating system as a Windows service. Avantra Automation can start and stop those Windows services but Avantra does not know if dependent Windows services should be started or stopped. If you want to start and stop those dependent Windows services as well, then activate it with this parameter.

Reference Data


Configures Checks	None
Default Value
Unit	Boolean

Syb_ConfigExclude

This monitoring parameter defined a comma separated list of all configuration parameters to be excluded from Syb_Config.

Reference Data


Configures Checks	Syb_Config
Default Value
Unit	String

Syb_ConfigOsOverwrite

This monitoring parameter can define an operating system of the database host.

Reference Data


Configures Checks	Syb_Config
Default Value
Unit	Enum

SYB_FullBackupAgeCrit

This monitoring parameter checks the database against dump_type DATABASE (full) and CUMULATIVE (incremental). The check status is set to Critical if the last successful full backup is older than the defined number of days. You can define overriding this value on a per-day level using the corresponding Monitoring Parameter Exception.

Reference Data


Configures Checks	SYB_BACKUP
Default Value	7
Unit	Days

SYB_FullBackupAgeWarn

This monitoring parameter checks the database against dump_type DATABASE (full) and CUMULATIVE (incremental). If the last successful backup is older than the defined number of days but not older than FullBackupAgeCrit days, the check status is set to Warning. You can define overriding this value on a per-day level using the corresponding Monitoring Parameter Exception.

Reference Data


Configures Checks	SYB_BACKUP
Default Value	1
Unit	Days

Syb_SaptoolsCreds

This monitoring parameter defines a credential type to use for database query. If left empty, the default monitoring credentials are used.

Reference Data


Configures Checks	Syb_Config
Default Value
Unit	Enum

SYBBackupExclude

Comma-separated list of database names that are ignored from SYB_Backup. Spaces before or after the comma are gently ignored. Excluded databases will still appear in the SYB_Backup table display, but are marked as Excluded → Yes. Most databases that usually require no backup up are already excluded by default.

SAP's Database Administration guide for SAP Business Suite on SAP ASE notes that backups are optional for certain databases, so you may choose to add additional ones to the exclusion list as needed.

Reference Data


Configures Checks	SYB_Backup
Default Value	model; saptempdb; sybsecurity; sybsystemdb; sybsystemprocs; tempdb
Unit	String

SYBBackupOKDisplayMax

Defines how many successful backups will be displayed in the table of SYB_Backup. This history is just for your convenience. You may reduce this parameter to 1 if you want to see only the latest successful backup.

Reference Data


Configures Checks	SYB_Backup
Default Value	5
Unit	Number

SYBBackupSelectRange

SYB_Backup looks for the defined number of days back to find successful backups. The default value is 60 days, so usually, there is no need to change this parameter since backups must be made far more often.

Reference Data


Configures Checks	SYB_Backup
Default Value	60
Unit	Days

SYBBackupStatDelayTimeCrit

If the running time of a Sybase backup is above 100 percent of the usual average runtime and above the defined number of minutes, the check status is set to Critical.

Reference Data


Configures Checks	SYB_BackupStat
Default Value	30
Unit	Minutes

SYBBackupStatDelayTimeWarn

If the running time of a Sybase backup is above 50 percent of the usual average runtime and above the defined number of minutes, the check status is set to Warning, unless the value is higher than the SYBBackupStatDelayTimeCrit threshold.

Reference Data


Configures Checks	SYB_BackupStat
Default Value	15
Unit	Minutes

SYBBackupStatExclude

Comma-separated list of database names that are ignored from SYB_BackupStat. Spaces before or after the comma are gently ignored. Excluded databases will still appear in the SYB_BackupStat table display, but are marked as Excluded → Yes. Most databases that usually require no backup up are already excluded by default.

SAP's Database Administration guide for SAP Business Suite on SAP ASE notes that backups are optional for certain databases, so you may choose to add additional ones to the exclusion list as needed.

Reference Data


Configures Checks	SYB_BackupStat
Default Value	model; saptempdb; sybsecurity; sybsystemdb; sybsystemprocs; tempdb
Unit	String

SYBBackupStatFailedDisplayTime

Defines the time how long a failed backup is displayed (status is defined by SYBBackupStatFailedStatus).

The check status will reset to OK after the defined number of minutes, in this monitoring parameter, has passed since the failed backup was detected.

Reference Data


Configures Checks	SYB_BackupStat
Default Value	60
Unit	Minutes

SYBBackupStatFailedStatus

Defines whether a failed backup reported by SYB_BackupStat shall be reported as Warning or Critical status.

Reference Data


Configures Checks	SYB_BackupStat
Default Value	Warning
Unit	Enum

SYBDBExCrit

If the predicted point in time when the data space is exceeded is within the upcoming defined number of hours, the check status is set to Critical.

Reference Data


Configures Checks	SYB_DataSpaces
Default Value	1
Unit	Hours

SYBDBExWarn

If the predicted point in time when the data space is exceeded is within the upcoming defined number of hours, but not within the upcoming SYBDBExCrit hours, the check status is set to Warning.

Reference Data


Configures Checks	SYB_DataSpaces
Default Value	12
Unit	Hours

SYBDBForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	SYB_DataSpaces
Default Value	Active
Unit	Enum

SYBDBUsageCrit

If the data space usage of a database exceeds the defined threshold the check status is set to Critical.

Reference Data


Configures Checks	SYB_DataSpaces
Default Value	95 %
Unit	% or KB/MB/GB

SYBDBUsageWarn

If the data space usage of a database exceeds the defined threshold, the check status is set to Warning, unless the SYBDBUsageCrit threshold is exceeded.

Reference Data


Configures Checks	SYB_DataSpaces
Default Value	80 %
Unit	% or KB/MB/GB

SYBErrorLogExcludeErrNums

You may use this parameter to exclude certain error numbers from being evaluated in SYB_ErrorLog and SYB_ErrorLogStat. Multiple numbers are defined in a comma-separated list. Leading and trailing blank spaces before or after the comma character are gently ignored.

Reference Data


Configures Checks	SYB_ErrorLog, SYB_ErrorLogStat
Default Value
Unit	String

SYBErrorLogTimeSpan

SYB_ErrorLogStat is designed to recover from check status Warning or Critical, so the check looks back for a time span defined by this monitoring parameter only.

Reference Data


Configures Checks	SYB_ErrorLogStat
Default Value	60
Unit	Minutes

SYBLogBackupAgeCrit

If the last transaction log dump is above the defined number of minutes ago, the check result is Critical.

Reference Data


Configures Checks	SYB_LogBackup
Default Value	120
Unit	Minutes

SYBLogBackupAgeWarn

If the last transaction log dump is above the defined number of minutes ago, but below SYBLogBackupAgeCrit minutes, the check status is Warning.

Reference Data


Configures Checks	SYB_LogBackup
Default Value	60
Unit	Minutes

SYBLogBackupExclude

You may use this parameter to exclude databases from being checked by SYB_LogBackup. The names of the databases are defined in a comma-separated list. Leading and trailing blank spaces before or after the comma character are gently ignored.

By default, many system databases are already excluded by default. However, databases are still checked for the full transaction log, no matter if excluded or not.

Reference Data


Configures Checks	SYB_LogBackup
Default Value	master; model; saptempdb; saptools; sybmgmtdb; sybsecurity; sybsystemdb; sybsystemprocs; tempdb
Unit	String

SYBLogExCrit

If the predicted point in time when the log space is exceeded is within the upcoming defined number of hours, the check status is set to Critical.

Reference Data


Configures Checks	SYB_LogSpaces
Default Value	1
Unit	Hours

SYBLogExWarn

If the predicted point in time when the log space is exceeded is within the upcoming defined number of hours, but not within the upcoming SYBLogExCrit hours, the check status is set to Warning.

Reference Data


Configures Checks	SYB_LogSpaces
Default Value	12
Unit	Hours

SYBLogForecast

Defines whether the forecasting algorithm is active or inactive. See Forecasting for more information.

Reference Data


Configures Checks	SYB_LogSpaces
Default Value	Active
Unit	Enum

SYBLogUsageCrit

If the data space usage of a database exceeds the defined threshold, the check status is set to Critical.

Reference Data


Configures Checks	SYB_LogSpaces
Default Value	95 %
Unit	% or KB/MB/GB

SYBLogUsageWarn

If the data space usage of a database exceeds the defined threshold the check status is set to Warning, unless the SYBLogUsageCrit threshold is exceeded.

Reference Data


Configures Checks	SYB_LogSpaces
Default Value	80 %
Unit	% or KB/MB/GB

TimeOutDBMonitor

Defines the timeout for Avantra Agent child processes performing Database checks (in seconds). If the value exceeds, the process is terminated.

Reference Data


Configures Checks	DBCONNECT, ORA_BACKUP
Default Value	180
Unit	Seconds

ADADataExCrit
- Reference Data
ADADataExWarn
- Reference Data
ADADataForecast
- Reference Data
ADADataUsageCrit
- Reference Data
ADADataUsageWarn
- Reference Data
ADALogExCrit
- Reference Data
ADALogExWarn
- Reference Data
ADALogForecast
- Reference Data
ADALogUsageCrit
- Reference Data
ADALogUsageWarn
- Reference Data
ANYBackupFullCritAge
- Reference Data
ANYBackupFullWarnAge
- Reference Data
ANYBackupSelectRange
- Reference Data
ANYConnectionsNumCrit
- Reference Data
ANYConnectionsNumWarn
- Reference Data
ANYDBExCrit
- Reference Data
ANYDBExWarn
- Reference Data
ANYDBForecast
- Reference Data
ANYDBUsageCrit
- Reference Data
ANYDBUsageWarn
- Reference Data
ANYLogExCrit
- Reference Data
ANYLogExWarn
- Reference Data
ANYLogForecast
- Reference Data
ANYLogUsageCrit
- Reference Data
ANYLogUsageWarn
- Reference Data
ANYMessagesExclude
- Reference Data
ANYMessagesNumCrit
- Reference Data
ANYMessagesNumWarn
- Reference Data
ANYMessagesStatExclude
- Reference Data
ANYMessagesStatNumCrit
- Reference Data
ANYMessagesStatNumWarn
- Reference Data
ANYMessagesStatTimespan
- Reference Data
AutoChangeDetectionIgnore
- Reference Data
BackupAgeCrit
- Description
- Reference Data
BackupAgeWarn
- Reference Data
BackupResetRTMTime
- Reference Data
DB2BackupStatWaitTime
- Reference Data
DB2CBOMaxAge
- Reference Data
DB2CBONumEntriesUpdCrit
- Reference Data
DB2CBONumEntriesUpdWarn
- Reference Data
DB2DBRemote
- Reference Data
DB2DiagLogCountCrit
- Reference Data
DB2DiagLogCountWarn
- Reference Data
DB2DiagLogExprCrit
- Reference Data
DB2DiagLogExprWarn
- Reference Data
DB2DiagLogTimeSpan
- Reference Data
DB2ExpSQLExclude
- Reference Data
DB2ExpSQLExcludeShow
- Reference Data
DB2ExpSQLLogicalReadCrit
- Reference Data
DB2ExpSQLLogicalReadWarn
- Reference Data
DB2ExpSQLPhysicalReadCrit
- Reference Data
DB2ExpSQLPhysicalReadWarn
- Reference Data
DB2FSLogActiveCrit
- Reference Data
DB2FSLogActiveWarn
- Reference Data
DB2FSLogArchCrit
- Reference Data
DB2FSLogArchExCrit
- Reference Data
DB2FSLogArchExWarn
- Reference Data
DB2FSLogArchForecast
- Reference Data
DB2FSLogArchWarn
- Reference Data
DB2LogExCrit
- Reference Data
DB2LogExWarn
- Reference Data
DB2LogForecast
- Reference Data
DB2LogUsageCrit
- Reference Data
DB2LogUsageWarn
- Reference Data
DB2NumFailArchLogsCrit
- Reference Data
DB2NumFailArchLogsWarn
- Reference Data
DB2TableSpaceExCrit
- Reference Data
DB2TableSpaceExWarn
- Reference Data
DB2TableSpaceForecast
- Reference Data
DB2TableSpaceUsageCrit
- Reference Data
DB2TableSpaceUsageWarn
- Reference Data
DBConnectErrsCrit
- Reference Data
DBConnectJdbcUrl
- Reference Data
FullBackupAgeCrit
- Reference Data
FullBackupAgeWarn
- Reference Data
HDBAdmissionMaxRows
- Reference Data
HDBAdmissionStatus
- Reference Data
HDBAdmissionTimeSpan
- Reference Data
HDBAlertsErrorCountCrit
- Reference Data
HDBAlertsExcludeIDs
- Reference Data
HDBAlertsHighCountCrit
- Reference Data
HDBAlertsLowCountWarn
- Reference Data
HDBAlertsMediumCountWarn
- Reference Data
HDBAlertsTimeSpan
- Reference Data
HDBBackupCompleteSelectRange
- Reference Data
HDBBackupPreparedWaitingOnSnapDelay
- Reference Data
HDBCertificateValidityCrit
- Reference Data
HDBCertificateValidityWarn
- Reference Data
HDBCertificateValidityIgnore
- Reference Data
HDBCertificatePurposes
- Reference Data
HDBCertificateUsages
- Reference Data
HDBCPULoadAverageTime
- Reference Data
HDBCPULoadCrit
- Reference Data
HDBCPULoadWarn
- Reference Data
HDBDeltaMergesNumCrit
- Reference Data
HDBDeltaMergesNumWarn
- Reference Data
HDBDeltaMergesTimeCrit
- Reference Data
HDBDeltaMergesTimeWarn
- Reference Data
HDBDisksUsageCrit
- Reference Data
HDBDisksUsageWarn
- Reference Data
HDBDisksLogExCrit
- Reference Data
HDBDisksLogExWarn
- Reference Data
HDBDisksLogUsageCrit
- Reference Data
HDBDisksLogUsageWarn
- Reference Data
HDBDisksLogBackupUsageCrit
- Reference Data
HDBDisksLogBackupUsageWarn
- Reference Data
HDBExcludeStorageDeviceIDs
- Reference Data
HDBExcludeStorageIDs
- Reference Data
HDBExcludeStorageTypes
- Reference Data
HDBExpSQLExclude
- Reference Data
HDBExpSQLTimePctCrit
- Reference Data
HDBExpSQLTimePctWarn
- Reference Data
HDBJobNameExclude
- Reference Data
HDBJobRuntimeCrit
- Reference Data
HDBJobRuntimeWarn
- Reference Data
HDBLandscapeSeverity
- Reference Data
HDBLicenseExpireTimeCrit
- Reference Data
HDBLicenseExpireTimeWarn
- Reference Data
HDBLicenseMemoryConsumCrit
- Reference Data
HDBLicenseMemoryConsumWarn
- Reference Data
HDBLogBackupConsecutiveFailedThreshold
- Reference Data
HDBLogBackupTimeSpan
- Reference Data
HDBLogFilesCritCount
- Reference Data
HDBLogFilesWarnCount
- Reference Data
HDBMemoryPeakUsageCrit
- Reference Data
HDBMemoryPeakUsageWarn
- Reference Data
HDBMemoryPhysicalUsageCrit
- Reference Data
HDBMemoryPhysicalUsageWarn
- Reference Data
HDBMemoryServicesUsageCrit
- Reference Data
HDBMemoryServicesUsageWarn
- Reference Data
HDBSystemReplDelayCrit
- Reference Data
HDBSystemReplDelayWarn
- Reference Data
HDBSystemReplIgnoreReplicationStatus
- Reference Data
HDBSystemReplIgnoreSecondaryActive
- Reference Data
HDBSystemReplIgnoreSecondaryFullyRecoverable
- Reference Data
HDBSystemReplNotFoundStatus
- Reference Data
HDBTableAllocationCrit
- Reference Data
HDBTableAllocationWarn
- Reference Data
HDBTableRowCountCrit
- Reference Data
HDBTableRowCountExclude
- Reference Data
HDBTableRowCountTopTables
- Reference Data
HDBTableRowCountWarn
- Reference Data
HDBTenantMemoryPeakUsageCrit
- Reference Data
HDBTenantMemoryPeakUsageWarn
- Reference Data
MSSBackupAgeMasterCrit
- Reference Data
MSSBackupAgeMasterWarn
- Reference Data
MSSBackupAgeMsdbCrit
- Reference Data
MSSBackupAgeMsdbWarn
- Reference Data
MSSBackupExclude
- Reference Data
MSSDBExCrit
- Reference Data
MSSDBExWarn
- Reference Data
MSSDBForecast
- Reference Data
MSSDBUsageCrit
- Reference Data
MSSDBUsageWarn
- Reference Data
MSSDBRemote
- Reference Data
MSSExpSQLExclude
- Reference Data
MSSExpSQLExcludeShow
- Reference Data
MSSExpSQLLogicalReadCrit
- Reference Data
MSSExpSQLLogicalReadWarn
- Reference Data
MSSExpSQLNumTopRecs
- Reference Data
MSSExpSQLPhysicalReadCrit
- Reference Data
MSSExpSQLPhysicalReadWarn
- Reference Data
MSSLogBckAgeCrit
- Reference Data
MSSLogBckAgeWarn
- Reference Data
MSSLogExCrit
- Reference Data
MSSLogExWarn
- Reference Data
MSSLogForecast
- Reference Data
MSSLogUsageCrit
- Reference Data
MSSLogUsageWarn
- Reference Data
MSSUseNTLMv2
- Reference Data
ORAAlertLogCountCrit
- Reference Data
ORAAlertLogCountWarn
- Reference Data
ORAAlertLogExprCrit
ORAAlertLogExprWarn
ORAAlertLogLocation
- Reference Data
ORAAlertLogTimeSpan
- Reference Data
ORABackupSkipFilesCheck
- Reference Data
ORABackupTool
- Reference Data
ORABrbackupDelayCrit
- Reference Data
ORABrbackupDelayTimeCrit
- Reference Data
ORABrbackupDelayTimeWarn
- Reference Data
ORABrbackupDelayWarn
- Reference Data
ORABrbackupOfflineDelayCrit
- Reference Data
ORABrbackupSuccessFIDs
- Reference Data
ORABrToolsSchema
- Reference Data
ORABrToolsSelectRange
- Reference Data
ORADataFileIncrementsCrit
- Reference Data
ORADataFileIncrementsWarn
- Reference Data
ORADataGuardDBCount
- Reference Data
ORADBAOperAgeCrit
- Reference Data
ORADBAOperAgeWarn
- Reference Data
ORADBAOperFunctionIDs
- Reference Data
ORADBAOperSelectRange
- Reference Data
ORADBRemote
- Reference Data
ORAEnqueueDeadLocksCrit
- Reference Data
ORAEnqueueDeadLocksWarn
- Reference Data
ORAEnqueueTimeoutsCrit
- Reference Data
ORAEnqueueTimeoutsWarn
- Reference Data
ORAEnqueueTimeSpan
- Reference Data
ORAEnqueueWaitsCrit
- Reference Data
ORAEnqueueWaitsWarn
- Reference Data
ORAExpSQLExclude
- Reference Data
ORAExpSQLExcludeShow
- Reference Data
ORAExpSQLGetCrit
- Reference Data
ORAExpSQLGetWarn
- Reference Data
ORAExpSQLReadCrit
- Reference Data
ORAExpSQLReadWarn
- Reference Data
ORAExtentsUsageCrit
- Reference Data
ORAExtentsUsageWarn
- Reference Data
ORAFSLogArchCrit
- Reference Data
ORAFSLogArchWarn
- Reference Data
ORAFSLogArchExCrit
- Reference Data
ORAFSLogArchExWarn
- Reference Data
ORAFSLogArchForecast
- Reference Data
ORAFSLogArchLocation
- Reference Data
ORAHomeDir
- Reference Data
ORARMANSelectRange
- Reference Data
ORASAPToolsEnable
- Reference Data
ORASAPToolsSchema
- Reference Data
ORASegsChkWaitTime
- Reference Data
ORASessionsCountWait
- Reference Data
ORASessionsIgnoreWaitClass
- Reference Data
ORASessionsTimeWaitCrit
- Reference Data
ORASessionsTimeWaitWarn
- Reference Data
ORATableSpaceExCrit
- Reference Data
ORATableSpaceExWarn
- Reference Data
ORATableSpaceForecast
- Reference Data
ORATableSpaceUsageCrit
- Reference Data
ORATableSpaceUsageWarn
- Reference Data
ORATableSpaceUseSegments
- Reference Data
ORATNSAdminDir
- Reference Data
ORATNSAlias
- Reference Data
PerfDataCollection
- Reference Data
PGSQLBloatIndexPctCrit
- Reference Data
PGSQLBloatIndexPctWarn
- Reference Data
PGSQLBloatTablePctCrit
- Reference Data
PGSQLBloatTablePctWarn
- Reference Data
PGSQLConnectionsUsedCrit
- Reference Data
PGSQLConnectionsUsedWarn
- Reference Data
PGSQLDeadlocksCrit
- Reference Data
PGSQLDeadlocksWarn
- Reference Data
PGSQLIdleInTransactionsCrit
- Reference Data
PGSQLIdleInTransactionsWarn
- Reference Data
PGSQLLongTransactionsCrit
- Reference Data
PGSQLLongTransactionsWarn
- Reference Data
PGSQLReplicationSlotLagCrit
- Reference Data
PGSQLReplicationSlotLagWarn
- Reference Data
PGSQLTempFileCrit
- Reference Data
PGSQLTempFileWarn
- Reference Data
PGSQLTransactionIdletime
- Reference Data
PGSQLTransactionRuntime
- Reference Data
PredictiveAnalyticsEngine
- Reference Data
RelevantDailyCheckDetails
- Reference Data
RunDailyCheckOnWE
- Reference Data
RUNJSAllowDBWrite
- Reference Data
SIQBackupSelectRange
- Reference Data
SIQCatalogCacheUsageCrit
- Reference Data
SIQCatalogCacheUsageWarn
- Reference Data
SIQConnectionsNumCrit
- Reference Data
SIQConnectionsNumWarn
- Reference Data
SIQDataFilesUsageCrit
- Reference Data
SIQDataFilesUsageWarn
- Reference Data
SIQDataSpacesExCrit
- Reference Data
SIQDataSpacesExWarn
- Reference Data
SIQDataSpacesForecast
- Reference Data
SIQDataSpacesUsageCrit
- Reference Data
SIQDataSpacesUsageWarn
- Reference Data
SIQLongTransactionsWarn
- Reference Data
SIQLongTransactionsCrit
- Reference Data
SIQMainCacheUsageCrit
- Reference Data
SIQMainCacheUsageWarn
- Reference Data
SIQOperationsWaitingCrit
- Reference Data
SIQOperationsWaitingWarn
- Reference Data
SIQTempCacheUsageCrit
- Reference Data
SIQTempCacheUsageWarn
- Reference Data
SIQThreadsWarn
- Reference Data
SIQThreadsCrit
- Reference Data
SIQTransactionRuntime
- Reference Data
StartStopDependentWINService
- Reference Data
Syb_ConfigExclude
- Reference Data
Syb_ConfigOsOverwrite
- Reference Data
SYB_FullBackupAgeCrit
- Reference Data
SYB_FullBackupAgeWarn
- Reference Data
Syb_SaptoolsCreds
- Reference Data
SYBBackupExclude
- Reference Data
SYBBackupOKDisplayMax
- Reference Data
SYBBackupSelectRange
- Reference Data
SYBBackupStatDelayTimeCrit
- Reference Data
SYBBackupStatDelayTimeWarn
- Reference Data
SYBBackupStatExclude
- Reference Data
SYBBackupStatFailedDisplayTime
- Reference Data
SYBBackupStatFailedStatus
- Reference Data
SYBDBExCrit
- Reference Data
SYBDBExWarn
- Reference Data
SYBDBForecast
- Reference Data
SYBDBUsageCrit
- Reference Data
SYBDBUsageWarn
- Reference Data
SYBErrorLogExcludeErrNums
- Reference Data
SYBErrorLogTimeSpan
- Reference Data
SYBLogBackupAgeCrit
- Reference Data
SYBLogBackupAgeWarn
- Reference Data
SYBLogBackupExclude
- Reference Data
SYBLogExCrit
- Reference Data
SYBLogExWarn
- Reference Data
SYBLogForecast
- Reference Data
SYBLogUsageCrit
- Reference Data
SYBLogUsageWarn
- Reference Data
TimeOutDBMonitor
- Reference Data

ADADataExCrit​

Reference Data​

ADADataExWarn​

Reference Data​

ADADataForecast​

Reference Data​

ADADataUsageCrit​

Reference Data​

ADADataUsageWarn​

Reference Data​

ADALogExCrit​

Reference Data​

ADALogExWarn​

Reference Data​

ADALogForecast​

Reference Data​

ADALogUsageCrit​

Reference Data​

ADALogUsageWarn​

Reference Data​

ANYBackupFullCritAge​

Reference Data​

ANYBackupFullWarnAge​

Reference Data​

ANYBackupSelectRange​

Reference Data​

ANYConnectionsNumCrit​

Reference Data​

ANYConnectionsNumWarn​

Reference Data​

ANYDBExCrit​

Reference Data​

ANYDBExWarn​

Reference Data​

ANYDBForecast​

Reference Data​

ANYDBUsageCrit​

Reference Data​

ANYDBUsageWarn​

Reference Data​

ANYLogExCrit​

Reference Data​

ANYLogExWarn​

Reference Data​

ANYLogForecast​

Reference Data​

ANYLogUsageCrit​

Reference Data​

ANYLogUsageWarn​

Reference Data​

ANYMessagesExclude​

Reference Data​

ANYMessagesNumCrit​

Reference Data​

ANYMessagesNumWarn​

Reference Data​

ANYMessagesStatExclude​

Reference Data​

ANYMessagesStatNumCrit​

Reference Data​

ANYMessagesStatNumWarn​

Reference Data​

ANYMessagesStatTimespan​

Reference Data​

AutoChangeDetectionIgnore​

Reference Data​

BackupAgeCrit​

Description​

Reference Data​

BackupAgeWarn​

Reference Data​

BackupResetRTMTime​

Reference Data​

DB2BackupStatWaitTime​

Reference Data​

DB2CBOMaxAge​

Reference Data​

DB2CBONumEntriesUpdCrit​

Reference Data​

DB2CBONumEntriesUpdWarn​

ADADataExCrit

Reference Data

ADADataExWarn

Reference Data

ADADataForecast

Reference Data

ADADataUsageCrit

Reference Data

ADADataUsageWarn

Reference Data

ADALogExCrit

Reference Data

ADALogExWarn

Reference Data

ADALogForecast

Reference Data

ADALogUsageCrit

Reference Data

ADALogUsageWarn

Reference Data

ANYBackupFullCritAge

Reference Data

ANYBackupFullWarnAge

Reference Data

ANYBackupSelectRange

Reference Data

ANYConnectionsNumCrit

Reference Data

ANYConnectionsNumWarn

Reference Data

ANYDBExCrit

Reference Data

ANYDBExWarn

Reference Data

ANYDBForecast

Reference Data

ANYDBUsageCrit

Reference Data

ANYDBUsageWarn

Reference Data

ANYLogExCrit

Reference Data

ANYLogExWarn

Reference Data

ANYLogForecast

Reference Data

ANYLogUsageCrit

Reference Data

ANYLogUsageWarn

Reference Data

ANYMessagesExclude

Reference Data

ANYMessagesNumCrit

Reference Data

ANYMessagesNumWarn

Reference Data

ANYMessagesStatExclude

Reference Data

ANYMessagesStatNumCrit

Reference Data

ANYMessagesStatNumWarn

Reference Data

ANYMessagesStatTimespan

Reference Data

AutoChangeDetectionIgnore

Reference Data

BackupAgeCrit

Description

Reference Data

BackupAgeWarn

Reference Data

BackupResetRTMTime

Reference Data

DB2BackupStatWaitTime

Reference Data

DB2CBOMaxAge

Reference Data

DB2CBONumEntriesUpdCrit

Reference Data

DB2CBONumEntriesUpdWarn