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.

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

ADADataExCrit

Configure critical threshold for data area exhaustion

Description

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

ADA_DATAAREA

Default Value

1

Unit

Hours

ADADataExWarn

Configure warning threshold for data area exhaustion

Description

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

ADA_DATAAREA

Default Value

12

Unit

Hours

ADADataForecast

Enables forecasting for ADA_DATAAREA check

Description

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

Reference Data
Configures

ADA_DATAAREA

Default Value

Active

Unit

Enum (Active/Inactive)

ADADataUsageCrit

Configure critical threshold for data area usage

Description

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

You can define the threshold either in the 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

ADA_DATAAREA

Default Value

98

Unit

%

ADADataUsageWarn

Configure warning threshold for data area usage

Description

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.

You can define the threshold either in the 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

ADA_DATAAREA

Default Value

95

Unit

%

ADALogExCrit

Configure critical threshold for log area exhaustion

Description

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

ADA_LOGAREA

Default Value

1

Unit

Hours

ADALogExWarn

Configure warning threshold for log area exhaustion

Description

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

ADA_LOGAREA

Default Value

12

Unit

Hours

ADALogForecast

Enables forecasting for ADA_LOGAREA check

Description

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

Reference Data
Configures

ADA_LOGAREA

Default Value

Active

Unit

Enum (Active/Inactive)

ADALogUsageCrit

Configure critical threshold for log area usage

Description

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

You can define the threshold either in the 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

ADA_LOGAREA

Default Value

95

Unit

%

ADALogUsageWarn

Configure warning threshold for log area usage

Description

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.

You can define the threshold either in the 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

ADA_LOGAREA

Default Value

80

Unit

%

ANYBackupFullCritAge

Configure Critical threshold for maximum full backup age of SAP SQL Anywhere Databases

Description

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

Reference Data
Configures

ANY_Backup

Default Value

15

Unit

Days

ANYBackupFullWarnAge

Configure Warning threshold for maximum full backup age of SAP SQL Anywhere Databases

Description

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

ANY_Backup

Default Value

8

Unit

Days

ANYBackupSelectRange

Configure the time range for maintenance reports of SAP SQL Anywhere database backups

Description

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

ANY_Backup

Default Value

60

Unit

Days

ANYConnectionsNumCrit

Configure Critical threshold for ANY_Connections Check

Description

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

Reference Data
Configures

ANY_Connections

Default Value

200

Unit

Number

ANYConnectionsNumWarn

Configure Warning threshold for ANY_Connections Check

Description

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

ANY_Connections

Default Value

100

Unit

Number

ANYDBExCrit

Configure Critical threshold for dbspaces exhaustion

Description

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

ANY_DBSpaces

Default Value

1

Unit

Hours

ANYDBExWarn

Configure Warning threshold for dbspaces exhaustion

Description

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

ANY_DBSpaces

Default Value

12

Unit

Hours

ANYDBForecast

Enables forecasting for ANY_DBSpaces check

Description

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

Reference Data
Configures

ANY_DBSpaces

Default Value

Active

Unit

Enum (Active/Inactive)

ANYDBUsageCrit

Configures the Critical threshold for SAP SQL Anywhere dbspace usage check ANY_DBSpaces

Description

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

You can define the threshold either in the 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

ANY_DBSpaces

Default Value

95 %

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

ANYDBUsageWarn

Configures the Warning threshold for SAP SQL Anywhere dbspace usage check ANY_DBSpaces

Description

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.

You can define the threshold either in the 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

ANY_DBSpaces

Default Value

80 %

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

ANYLogExCrit

Configure Critical threshold for SAP SQL Anywhere transaction log exhaustion

Description

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

ANY_TransLog

Default Value

1

Unit

Hours

ANYLogExWarn

Configure Warning threshold for SAP SQL Anywhere transaction log exhaustion

Description

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

ANY_TransLog

Default Value

12

Unit

Hours

ANYLogForecast

Enables forecasting for ANY_TransLog check

Description

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

Reference Data
Configures

ANY_TransLog

Default Value

Active

Unit

Enum (Active/Inactive)

ANYLogUsageCrit

Configures the Critical threshold for SAP SQL Anywhere transaction log usage check ANY_TransLog

Description

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

You can define the threshold either in the 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

ANY_TransLog

Default Value

95 %

Unit

% or KB/MB/GB

ANYLogUsageWarn

Configures the Warning threshold for SAP SQL Anywhere transaction log usage check ANY_TransLog

Description

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.

You can define the threshold either in the 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

ANY_TransLog

Default Value

80 %

Unit

% or KB/MB/GB

ANYMessagesNumCrit

Configure Critical threshold for SAP SQL Anywhere erroneous server messages (daily check)

Description

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

ANY_Messages

Default Value

1

Unit

Number

ANYMessagesNumWarn

Configure Warning threshold for SAP SQL Anywhere erroneous or warning server messages (daily check)

Description

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

ANY_Messages

Default Value

1

Unit

Number

ANYMessagesExclude

Exclude server messages from check evaluation (ANY_Messages daily check)

Description

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

Reference Data
Configures

ANY_Messages

Default Value

n/a

Unit

String

ANYMessagesStatExclude

Exclude server messages from check evaluation (ANY_MessagesStat RealTime Monitoring check)

Description

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 1. 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

ANY_MessagesStat

Default Value

n/a

Unit

String

ANYMessagesStatNumCrit

Configure Critical threshold for SAP SQL Anywhere erroneous server messages

Description

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

ANY_MessagesStat

Default Value

1

Unit

Number

ANYMessagesStatNumWarn

Configure Warning threshold for SAP SQL Anywhere erroneous or warning server messages

Description

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

ANY_MessagesStat

Default Value

1

Unit

Number

ANYMessagesStatTimespan

Configures time span to look back for ANY_MessagesStat check

Description

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

ANY_MessagesStat

Default Value

60

Unit

Minutes

AutoChangeDetectionIgnore

Description

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

Unit

Keyword followed by comma separated value list, optionally followed by a semicolon followed by a keyword followed by comma separated value list, …​ Colon, semicolon, and comma must be escaped by \ (backslash) if used as a value.

BackupAgeCrit

Configure critical threshold for maximum backup age

Description

If the last successful Backup is older than BackupAgeCrit 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

DB2_BACKUP, DB2_BACKUPSTAT,MSS_DBBACKUP, ORA_BRBACKUP, ORA_BACKUP, ORA_BRBACKUPSTAT, SIQ_Backup

Default Value

7

Unit

Days

Monitoring Exception Parameter available

Yes

BackupAgeWarn

Configure warning threshold for maximum backup age

Description

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 define override this value on a per-day level using the corresponding Monitoring Exception Parameter.

Reference Data
Configures

DB2_BACKUP, DB2_BACKUPSTAT,MSS_DBBACKUP, ORA_BRBACKUP, ORA_BACKUP, ORA_BRBACKUPSTAT, SIQ_Backup

Default Value

1

Unit

Days

Monitoring Exception Parameter available

Yes

BackupResetRTMTime

Configure display time of RealTime Monitoring backup Check Results

Description

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

DB2_BACKUPSTAT, ORA_BRBACKUPSTAT

Default Value

8

Unit

Hours

DB2BackupStatWaitTime

Configure how often the DB2_BACKUPSTAT check is executed

Description

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

Reference Data
Configures

DB2_BACKUPSTAT

Default Value

0 (defaults to BASIC cycle interval)

Unit

Minutes

DB2CBOMaxAge

Configure age threshold for DB2 cost based optimizer statistics

Description

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

DB2_CBO_STATS

Default Value

7

Unit

Days

DB2CBONumEntriesUpdCrit

Define critical threshold for DB2 cost based optimizer check

Description

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

DB2_CBO_STATS

Default Value

1000

Unit

Number

DB2CBONumEntriesUpdWarn

Define warning threshold for DB2 cost based optimizer check

Description

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

DB2_CBO_STATS

Default Value

5000

Unit

Number

DB2DBRemote

Configure DB2 Database for Agentless Monitoring

Description

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

DB2_FSLOGARCH, DB2_DIAGLOG

Default Value

0

Unit

Boolean

DB2DiagLogCountCrit

Configure critical threshold for DB2 diag log monitoring

Description

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

Reference Data
Configures

DB2_DIAGLOG

Default Value

1

Unit

Number

DB2DiagLogCountWarn

Configure warning threshold for DB2 diag log monitoring

Description

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

DB2_DIAGLOG

Default Value

1

Unit

Number

DB2DiagLogExprCrit

Configure DB2 diag log entries considered critical

Description

Designates an entry in the DB2 diagnostics log as critical.

Reference Data
Configures

DB2_DIAGLOG

Default Value

(%%level%%' eq 'Severe')

Unit

Expression

DB2DiagLogExprWarn

Configure DB2 diag log entries considered warning

Description

Designates an entry in the DB2 diagnostics log as warning.

Reference Data
Configures

DB2_DIAGLOG

Default Value

(%%level%%' eq 'Error')

Unit

Expression

DB2DiagLogTimeSpan

Restricts the watch period of the DB2_DIAGLOG check

Description

Consider only the last DB2DiagLogTimeSpan minutes of the log file.

Reference Data
Configures

DB2_DIAGLOG

Default Value

60

Unit

Minutes

DB2ExpSQLExclude

Exclude statements depending on the name of their calling program from expensive SQL check

Description

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

DB2_ExpSQL

Default Value
Unit

String

DB2ExpSQLExcludeShow

Decide whether to show excluded SQL statements anyway

Description

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

Reference Data
Configures

DB2_ExpSQL

Default Value

1

Unit

Boolean

DB2ExpSQLLogicalReadCrit

Configure critical threshold for logical reads

Description

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

DB2_ExpSQL

Default Value

10

Unit

%

DB2ExpSQLLogicalReadWarn

Configure warning threshold for logical reads

Description

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

DB2_ExpSQL

Default Value

5

Unit

%

DB2ExpSQLPhysicalReadCrit

Configure critical threshold for physical reads

Description

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

DB2_ExpSQL

Default Value

10

Unit

%

DB2ExpSQLPhysicalReadWarn

Configure warning threshold for physical reads

Description

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

DB2_ExpSQL

Default Value

5

Unit

%

DB2FSLogActiveCrit

Configure critical usage thresholds for DB2 active log directory

Description

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.

You can define the threshold either in the 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

DB2_FSLOGARCH

Default Value

85 %

Unit

% or KB/MB/GB

DB2FSLogActiveWarn

Configure warning usage thresholds for DB2 active log directory

Description

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.

You can define the threshold either in the 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

DB2_FSLOGARCH

Default Value

70 %

Unit

% or KB/MB/GB

DB2FSLogArchCrit

Configure critical threshold for log archive usage

Description

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.

You can define the threshold either in the 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

DB2_FSLOGARCH

Default Value

85 %

Unit

% or KB/MB/GB

DB2FSLogArchExCrit

Configure critical threshold for log archive exhaustion

Description

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

DB2_FSLOGARCH

Default Value

1

Unit

Hours

DB2FSLogArchExWarn

Configure warning threshold for log archive exhaustion

Description

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

DB2_FSLOGARCH

Default Value

12

Unit

Hours

DB2FSLogArchForecast

Enables forecasting for DB2_FSLOGARCH check

Description

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

Reference Data
Configures

DB2_FSLOGARCH

Default Value

Active

Unit

Enum (Active/Inactive)

DB2FSLogArchWarn

Configure warning threshold for log archive usage

Description

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

You can define the threshold either in the 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

DB2_FSLOGARCH

Default Value

70 %

Unit

% or KB/MB/GB

DB2LogExCrit

Configure critical threshold for log usage exhaustion

Description

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

DB2_LOGUSAGE

Default Value

1

Unit

Hours

DB2LogExWarn

Configure warning threshold for log usage exhaustion

Description

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

DB2_LOGUSAGE

Default Value

12

Unit

Hours

DB2LogForecast

Enables forecasting for DB2_LOGUSAGE check

Description

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

Reference Data
Configures

DB2_LOGUSAGE

Default Value

Active

Unit

Enum (Active/Inactive)

DB2LogUsageCrit

Configure critical threshold for log usage

Description

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

You can define the threshold either in the 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

DB2_LOGUSAGE

Default Value

95

Unit

%

DB2LogUsageWarn

Configure warning threshold for log usage

Description

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

You can define the threshold either in the 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

DB2_LOGUSAGE

Default Value

80

Unit

%

DB2NumFailArchLogsCrit

Configure critical threshold for the number of transaction logs in failover archive

Description

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

DB2_FSLOGARCH

Default Value

5

Unit

Number

DB2NumFailArchLogsWarn

Configure warning threshold for the number of transaction logs in failover archive

Description

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

DB2_FSLOGARCH

Default Value

1

Unit

Number

DB2TableSpaceExCrit

Configure critical threshold for tablespace exhaustion

Description

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

DB2_TABLESPACES

Default Value

1

Unit

Hours

Monitoring Exception Parameter available

Yes

DB2TableSpaceExWarn

Configure warning threshold for tablespace exhaustion

Description

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

DB2_TABLESPACES

Default Value

12

Unit

Hours

Monitoring Exception Parameter available

Yes

DB2TableSpaceForecast

Enables forecasting for DB2_TABLESPACES check

Description

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

Reference Data
Configures

DB2_TABLESPACES

Default Value

Active

Unit

Enum (Active/Inactive)

DB2TableSpaceUsageCrit

Configure critical threshold for tablespace usage

Description

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

You can define the threshold either in the 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

DB2_TABLESPACES

Default Value

98

Unit

%

Monitoring Exception Parameter available

Yes

DB2TableSpaceUsageWarn

Configure warning threshold for tablespace usage

Description

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.

You can define the threshold either in the 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

DB2_TABLESPACES

Default Value

95

Unit

%

Monitoring Exception Parameter available

Yes

DBConnectErrsCrit

Configure sensitivity of the Database connect check

Description

Starting from DBConnectErrsCrit failed database connection attempts the check status will turn from Warning to Critical.

Reference Data
Configures

DBCONNECT

Default Value

1

Unit

Number

DBConnectJdbcUrl

Override the connection URL to access the SAP System Database

Description

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.

Reference Data
Configures

DBCONNECT

Unit

String

HDBAdmissionMaxRows

Configure the maximum number of entries to return

Description

Maximum number of rows to return from table M_ADMISSION_CONTROL_EVENTS.

Reference Data
Configures

HDB_Admission

Default Value

50

Unit

Number

HDBAdmissionStatus

Configure the status to generate in case of entries found within the watch period

Description

Define if the check result shall be reported as Warning or Critical status.

Reference Data
Configures

HDB_Admission

Default Value

Warning

Unit

Enum, either Warning or Critical

HDBAdmissionTimeSpan

Configure watch period for HDB_Admission RealTime Monitoring check

Description

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

Reference Data
Configures

HDB_Admission

Default Value

10

Unit

Minutes

HDBAlertsErrorCountCrit

Configure number of HANA alerts reported as Errors for Critical status

Description

The HDB_Alerts check turns to Critical if the number of alerts with rating Error found within the timespan defined by HDBAlertsTimeSpan is equal to or above HDBAlertsErrorCountCrit.

Please note that no matter how HDBAlertsErrorCountCrit is defined, the check status will at least be Warning starting from one alert with rating Error found within HDBAlertsTimeSpan.

Reference Data
Configures

HDB_Alerts

Default Value

1

Unit

Number

HDBAlertsExcludeIDs

Configure HANA alerts to be excluded from HDB_Alerts check

Description

You can exclude alerts from contributing to the check status by specifying the alert’s ID using parameter HDBAlertsExcludeIDs. Multiple entries must be separated by spaces, comma, or semicolon. HDBAlertsExcludeIDs's 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.

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

HDB_Alerts

Default Value
Unit

String

HDBAlertsHighCountCrit

Configure number of HANA alerts reported with high priority for Critical status

Description

The HDB_Alerts check turns to Critical if the number of alerts with rating High found within the timespan defined by HDBAlertsTimeSpan is equal to or above HDBAlertsHighCountCrit.

Please note that no matter how HDBAlertsHighCountCrit is defined, the check status will at least be Warning starting from one alert with high priority found within HDBAlertsTimeSpan.

Reference Data
Configures

HDB_Alerts

Default Value

1

Unit

Number

HDBAlertsLowCountWarn

Configure number of HANA alerts reported with Low priority for Warning status

Description

The HDB_Alerts check turns to Warning if the number of alerts with rating Low found within the timespan defined by HDBAlertsTimeSpan is equal to or above HDBAlertsLowCountWarn. The check status of HDB_Alerts will be Ok if no alerts with priorty above Low are found and if the number of Low priority alerts is below the threshold.

Reference Data
Configures

HDB_Alerts

Default Value

20

Unit

Number

HDBAlertsMediumCountWarn

Configure number of HANA alerts reported with Medium priority for Warning status

Description

The HDB_Alerts check turns to Warning if the number of alerts with rating Medium found within the timespan defined by HDBAlertsTimeSpan is equal to or above HDBAlertsMediumCountWarn. The check status of HDB_Alerts will be Ok if no alerts with priority above Medium are found and if the number of Medium priority alerts is below HDBAlertsMediumCountWarn threshold, and the number of Low priority alerts is below HDBAlertsLowCountWarn threshold.

Reference Data
Configures

HDB_Alerts

Default Value

1

Unit

Number

HDBAlertsTimeSpan

Configure time offset for the SAP HANA Alerts

Description

Restricts the watch period of the HDB_Alerts Check.

Reference Data
Configures

HDB_Alerts

Default Value

60

Unit

Minutes

HDBBackupCompleteSelectRange

Configure the time range for SAP HANA Backups

Description

Restricts the watch period of the HDB_Backup Check.

Reference Data
Configures

HDB_Backup

Default Value

60

Unit

Days

HDBBackupPreparedWaitingOnSnapDelay

Configure the allowed time for SAP HANA Backups in the "Prepared" status

Description

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

Reference Data
Configures

HDB_LogBackup

Default Value

5

Unit

Minutes

HDBCPULoadAverageTime

Define a time span during which SAP HANA nodes CPU usage is computed

Description

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

Reference Data
Configures

HDB_CPULoad

Default Value

10

Unit

Minutes

HDBCPULoadCrit

Configure a critical threshold for SAP HANA nodes CPU usage

Description

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

Reference Data
Configures

HDB_CPULoad

Default Value

90

Unit

%

HDBCPULoadWarn

Configure a warning threshold for SAP HANA nodes CPU usage

Description

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

HDB_CPULoad

Default Value

75

Unit

%

HDBDeltaMergesNumCrit

Configure a critical threshold for the number of delta merges

Description

If there are more than HDBDeltaMergesNumCrit taking longer than HDBDeltaMergesTimeCrit amount of time the check status of HDB_DeltaMerges turns to Critical.

Reference Data
Configures

HDB_DeltaMerges

Default Value

10

Unit

Number

HDBDeltaMergesNumWarn

Configure a warning threshold for the number of delta merges

Description

If there are more than HDBDeltaMergesNumWarn taking longer than HDBDeltaMergesTimeWarn amount of time the check status of HDB_DeltaMerges turns to Warning, unless a Critical threshold is exceeded.

Reference Data
Configures

HDB_DeltaMerges

Default Value

5

Unit

Number

HDBDeltaMergesTimeCrit

Configure a critical threshold for delta merge runtime

Description

If there are more than HDBDeltaMergesNumCrit taking longer than HDBDeltaMergesTimeCrit amount of time the check status of HDB_DeltaMerges turns to Critical.

Reference Data
Configures

HDB_DeltaMerges

Default Value

20

Unit

Minutes

HDBDeltaMergesTimeWarn

Configure a warning threshold for delta merge runtime

Description

If there are more than HDBDeltaMergesNumWarn taking longer than HDBDeltaMergesTimeWarn amount of time the check status of HDB_DeltaMerges turns to Warning, unless a Critical threshold is exceeded.

Reference Data
Configures

HDB_DeltaMerges

Default Value

10

Unit

Minutes

HDBDisksUsageCrit

Configure a critical threshold for SAP HANA disk usage

Description

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

Reference Data
Configures

HDB_Disks

Default Value

90 %

Unit

% or KB/MB/GB

HDBDisksUsageWarn

Configure a warning threshold for SAP HANA disk usage

Description

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

Reference Data
Configures

HDB_Disks

Default Value

80 %

Unit

% or KB/MB/GB

HDBDisksLogExCrit

Critical threshold for forecasting of HDB_DisksLog

Description

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

Reference Data
Configures

HDB_DisksLog

Default Value

1

Unit

Hours

HDBDisksLogExWarn

Warning threshold for forecasting of HDB_DisksLog

Description

If the predicted point in time when the SAP HANA Log Area space is exceeded lies within the upcoming HDBDisksLogExWarn hours, but not within the HDBDisksLogExCrit hours, the check status of this HDB_DisksLog is set to Warning.

Reference Data
Configures

HDB_DisksLog

Default Value

1

Unit

Hours

HDBDisksLogUsageCrit

Configure a critical threshold for SAP HANA Log Area usage

Description

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

Reference Data
Configures

HDB_DisksLog

Default Value

20%

Unit

% or KB/MB/GB

HDBDisksLogUsageWarn

Configure a warning threshold for SAP HANA Log Area usage

Description

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

Reference Data
Configures

HDB_DisksLog

Default Value

10%

Unit

% or KB/MB/GB

HDBDisksLogBackupUsageCrit

Configure a critical threshold for SAP HANA Log Backup usage

Description

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

Reference Data
Configures

HDB_DisksLogBackup

Default Value

85%

Unit

% or KB/MB/GB

HDBDisksLogBackupUsageWarn

Configure a warning threshold for SAP HANA Log Backup usage

Description

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

Reference Data
Configures

HDB_DisksLogBackup

Default Value

70%

Unit

% or KB/MB/GB

HDBExcludeStorageDeviceIDs

Configure HANA disk checks to exclude storage devices listed by storage device ID

Description

You can exclude storage devices from contributing to the check status by specifying the storage device ID using parameter HDBExcludeStorageDeviceIDs. Multiple entries must be separated by comma or semicolon. HDBExcludeStorageDeviceIDs's 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.

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

Reference Data
Configures

HDB_Disks, HDB_DisksLog, and HDB_DisksLogBackup

Default Value
Unit

String

HDBExcludeStorageIDs

Configure HANA disk checks to exclude storage devices listed by storage ID

Description

You can exclude storage devices from contributing to the check status by specifying the storage ID using parameter HDBExcludeStorageIDs. Multiple entries must be separated by comma or semicolon. HDBExcludeStorageIDs's 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.

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

Reference Data
Configures

HDB_Disks, HDB_DisksLog, and HDB_DisksLogBackup

Default Value
Unit

String

HDBExcludeStorageTypes

Configure HANA disk checks to exclude storage devices listed by storage type

Description

You can exclude storage devices from contributing to the check status by specifying the storage device type (e.g. Data, Log_backup) using parameter HDBExcludeStorageTypes. 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.

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

Reference Data
Configures

HDB_Disks, HDB_DisksLog, and HDB_DisksLogBackup

Default Value
Unit

String

HDBExpSQLExclude

Exclude statements from HDB expensive SQL check

Description

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

HDB_ExpSQL

Default Value
Unit

String

HDBExpSQLTimePctCrit

Configure a critical threshold for an expensive SQL Statement

Description

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

Reference Data
Configures

HDB_ExpSQL

Default Value

10

Unit

%

HDBExpSQLTimePctWarn

Configure a warning threshold for an expensive SQL Statement

Description

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

Reference Data
Configures

HDB_ExpSQL

Default Value

5

Unit

%

HDBJobNameExclude

Configure HDB_JobRuntime check to exclude job names

Description

You can exclude job names from contributing to the check status by specifying the job names using parameter HDBJobNameExclude. Multiple entries must be separated by comma or semicolon. The syntax of HDBJobNameExclude 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.

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

HDB_JobRuntime

Default Value

Backup

Unit

String

HDBJobRuntimeCrit

Configure a critical threshold for SAP HANA Jobs

Description

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

Reference Data
Configures

HDB_JobRuntime

Default Value

10

Unit

Minutes

HDBJobRuntimeWarn

Configure a warning threshold for SAP HANA Jobs

Description

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

Reference Data
Configures

HDB_JobRuntime

Default Value

5

Unit

Minutes

HDBLandscapeSeverity

Configure the severity of SAP HANA Landscape issues

Description

Define the severity of HDB_Landscape in case of a problem.

Reference Data
Configures

HDB_Landscape

Default Value

Warning

Unit

Enum

HDBLicenseExpireTimeCrit

Configure a critical threshold for SAP HANA License Expiration

Description

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

Reference Data
Configures

HDB_License

Default Value

7

Unit

Days

HDBLicenseExpireTimeWarn

Configure a warning threshold for SAP HANA License Expiration

Description

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

Reference Data
Configures

HDB_License

Default Value

30

Unit

Days

HDBLicenseMemoryConsumCrit

Description

Memory relation of the used memory to the licensed memory.

Reference Data
Configures

HDB_License

Default Value

90

Unit

%

HDBLicenseMemoryConsumWarn

Description

Memory relation of the used memory to the licensed memory.

Reference Data
Configures

HDB_License

Default Value

80

Unit

%

HDBLogBackupTimeSpan

Configure time offset for the SAP HANA Log Backup check.

Description

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

Reference Data
Configures

HDB_LogBackup

Default Value

60

Unit

Minutes

HDBLogFilesCritCount

Configure a Critical threshold for the number of locked log files.

Description

Configures the Critical threshold of the HDB_LogFiles check; if more locked log files are found the check will raise a Critical alert.

Reference Data
Configures

HDB_LogFiles

Default Value

5

Unit

Number

HDBLogFilesWarnCount

Configure a Warning threshold for the number of locked log files.

Description

Configures the Warning threshold of the HDB_LogFiles check; if more locked log files are found the check will raise a Warning alert.

Reference Data
Configures

HDB_LogFiles

Default Value

5

Unit

Number

HDBMemoryPeakUsageCrit

Configure a critical threshold for Peak Memory Usage

Description

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

Reference Data
Configures

HDB_MemoryPeak

Default Value

95%

Unit

% or KB/MB/GB

HDBMemoryPeakUsageWarn

Configure a warning threshold for Peak Memory Usage

Description

If the Database peak memory usage compared to the allocation limit exceeds the HDBMemoryPeakUsageWarn threshold, the check status is set to Warning unless the HDBMemoryPeakUsageCrit threshold is exceeded.

Reference Data
Configures

HDB_MemoryPeak

Default Value

90%

Unit

% or KB/MB/GB

HDBMemoryPhysicalUsageCrit

Configure a critical threshold for Physical Memory Usage

Description

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

Reference Data
Configures

HDB_MemoryPhysical

Default Value

95%

Unit

% or KB/MB/GB

HDBMemoryPhysicalUsageWarn

Configure a warning threshold for Physical Memory Usage

Description

If a host’s physical memory usage exceeds the HDBMemoryPhysicalUsageWarn threshold, the check status is set to Warning, unless the HDBMemoryPhysicalUsageCrit threshold is exceeded.

Reference Data
Configures

HDB_MemoryPhysical

Default Value

90%

Unit

% or KB/MB/GB

HDBMemoryServicesUsageCrit

Configure a critical threshold for Service Memory Usage

Description

If a service’s memory usage exceeds HDBMemoryServicesUsageCrit percent or a service’s free memory falls below HDBMemoryServicesUsageCrit KB/MB/GB, the check status is set to Critical.

Reference Data
Configures

HDB_MemoryServices

Default Value

95%

Unit

% or KB/MB/GB

HDBMemoryServicesUsageWarn

Configure a warning threshold for Service Memory Usage

Description

If a service’s memory usage exceeds HDBMemoryServicesUsageWarn percent or a service’s free memory falls below HDBMemoryServicesUsageWarn KB/MB/GB, the check status is set to Warning, unless the HDBMemoryServicesUsageCrit threshold is exceeded.

Reference Data
Configures

HDB_MemoryServices

Default Value

90%

Unit

% or KB/MB/GB

HDBSystemReplDelayCrit

Configure critical threshold for system replication delay in seconds

Description

Configures the Critical threshold for system replication delay in seconds.

Reference Data
Configures

HDB_SystemReplDelay

Default Value

3600

Unit

Seconds

HDBSystemReplDelayWarn

Configure warning threshold for system replication delay in seconds

Description

Configures the Warning threshold for system replication delay in seconds.

Reference Data
Configures

HDB_SystemReplDelay

Default Value

30

Unit

Seconds

HDBSystemReplNotFoundStatus

Configure status of HDB_SystemReplication check

Description

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 HDBSystemReplNotFoundStatus parameter and thus enforce that system replication is configured.

Reference Data
Configures

HDB_SystemReplication

Default Value

OK

Unit

Enum (OK/Warning/Critical)

HDBTableAllocationCrit

Description

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

Reference Data
Configures

HDB_TableAllocationUse

Default Value

50

Unit

%

HDBTableAllocationWarn

Description

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

Reference Data
Configures

HDB_TableAllocationUse

Default Value

30

Unit

%

HDBTableRowCountCrit

Description

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

Reference Data
Configures

HDB_TableRowCount

Default Value

90

Unit

%

HDBTableRowCountExclude

Description

Define which tables have been excluded.

Reference Data
Configures

HDB_TableRowCount

Default Value
Unit

String

HDBTableRowCountTopTables

Description

Define how many top tables the check monitors.

Reference Data
Configures

HDB_TableRowCount

Default Value

10

Unit

Number

HDBTableRowCountWarn

Description

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

Reference Data
Configures

HDB_TableRowCount

Default Value

80

Unit

%

HDBTenantMemoryPeakUsageCrit

Configure a critical threshold for Tenant Peak Memory Usage

Description

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

Reference Data
Configures

HDB_TenantMemoryPeak

Default Value

95%

Unit

% or KB/MB/GB

HDBTenantMemoryPeakUsageWarn

Configure a warning threshold for Tenant Peak Memory Usage

Description

If the Database tenant peak memory usage compared to the allocation limit exceeds the HDBTenantMemoryPeakUsageWarn threshold, the check status is set to Warning unless the HDBTenantMemoryPeakUsageCrit threshold is exceeded.

Reference Data
Configures

HDB_TenantMemoryPeak

Default Value

90%

Unit

% or KB/MB/GB

MSSBackupAgeMasterCrit

Configure critical threshold for the MSSQL primary configuration Database backup

Description

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

Reference Data
Configures

MSS_DBBACKUP

Default Value

7

Unit

Days

MSSBackupAgeMasterWarn

Configure warning threshold for the MSSQL primary configuration Database backup

Description

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

Reference Data
Configures

MSS_DBBACKUP

Default Value

14

Unit

Days

MSSBackupAgeMsdbCrit

Configure critical threshold for the MSSQL MSDB Database backup

Description

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

Reference Data
Configures

MSS_DBBACKUP

Default Value

7

Unit

Days

MSSBackupAgeMsdbWarn

Configure warning threshold for the MSSQL MSDB Database backup

Description

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

Reference Data
Configures

MSS_DBBACKUP

Default Value

14

Unit

Days

MSSBackupExclude

Exclude databases from MSS_DBBACKUP check

Description

Comma-separated list of database names that are ignored from the MSS_DBBACKUP check. By default, the MSS_DBBACKUP 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

MSS_DBBACKUP

Unit

String

MSSDBExCrit

Configure threshold for MSSQL Database space exhaustion

Description

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

Reference Data
Configures

MSS_DBUSAGE

Default Value

1

Unit

Hours

MSSDBExWarn

Configure threshold for MSSQL Database space exhaustion

Description

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

Reference Data
Configures

MSS_DBUSAGE

Default Value

12

Unit

Hours

MSSDBForecast

Enable forecasting for MSS_DBUSAGE check

Description

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

Reference Data
Configures

MSS_DBUSAGE

Default Value

Active

Unit

Enum (Active/Inactive)

MSSDBUsageCrit

Configure critical threshold for MSSQL Database usage

Description

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

You can define the threshold either in the 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

MSS_DBUSAGE

Default Value

95

Unit

%

MSSDBUsageWarn

Configure warning threshold for MSSQL Database usage

Description

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

You can define the threshold either in the 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

MSS_DBUSAGE

Default Value

80

Unit

%

MSSDBRemote

Configure SQL Server Database for Agentless Monitoring

Description

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

MSS_DBUSAGE, MSS_LOGUSAGE

Default Value

0

Unit

Boolean

MSSExpSQLExclude

Exclude statements from expensive SQL check

Description

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

MSS_EXPSQL

Default Value
Unit

String

MSSExpSQLExcludeShow

Decide whether to show excluded SQL statements anyway

Description

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

Reference Data
Configures

MSS_EXPSQL

Default Value

1

Unit

Boolean

MSSExpSQLLogicalReadCrit

Configure critical threshold for logical reads

Description

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

Reference Data
Configures

MSS_EXPSQL

Default Value

10

Unit

%

MSSExpSQLLogicalReadWarn

Configure warning threshold for logical reads

Description

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

Reference Data
Configures

MSS_EXPSQL

Default Value

5

Unit

%

MSSExpSQLNumTopRecs

Configure expensive SQL check

Description

Limit the number of considered SQLstatements to the topmost MSSExpSQLNumTopRecs. This is due to performance reasons.

Reference Data
Configures

MSS_EXPSQL

Default Value

20000

Unit

Number

MSSExpSQLPhysicalReadCrit

Configure critical threshold for physical reads

Description

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

Reference Data
Configures

MSS_EXPSQL

Default Value

10

Unit

%

MSSExpSQLPhysicalReadWarn

Configure warning threshold for physical reads

Description

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

Reference Data
Configures

MSS_EXPSQL

Default Value

5

Unit

%

MSSLogBckAgeCrit

Configure critical threshold for MSSQL transaction log backup

Description

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

Reference Data
Configures

MSS_LOGBACKUP

Default Value

60

Unit

Minutes

MSSLogBckAgeWarn

Configure warning threshold for MSSQL transaction log backup

Description

If the transaction log for the SAP SID database is older than MSSLogBckAgeWarn minutes, but is not older than MSSLogBckAgeCrit minutes, the check status is set to Warning, unless the MSSLogExCrit threshold is exceeded.

Reference Data
Configures

MSS_LOGBACKUP

Default Value

30

Unit

Minutes

MSSLogExCrit

Configure critical threshold for transaction log exhaustion

Description

If the predicted point in time when the transaction log limit is exceeded is within the upcoming MSSLogExCrit hours, the check result of MSS_LOGUSAGE is set to Critical.

Reference Data
Configures

MSS_LOGUSAGE

Default Value

1

Unit

Hours

MSSLogExWarn

Configure warning threshold for transaction log exhaustion

Description

If the predicted point in time when the transaction log limit is exceeded is within the upcoming MSSLogExWarn hours, but not within the upcoming MSSDBExCrit hours, the check result of MSS_LOGUSAGE is set to Warning, unless the MSSDBUsageCrit threshold is exceeded.

Reference Data
Configures

MSS_LOGUSAGE

Default Value

12

Unit

Hours

MSSLogForecast

Enables forecasting for MSS_LOGUSAGE check

Description

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

Reference Data
Configures

MSS_LOGUSAGE

Default Value

Active

Unit

Enum (Active/Inactive)

MSSLogUsageCrit

Configure critical threshold for transaction log usage

Description

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

You can define the threshold either in the 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

MSS_LOGUSAGE

Default Value

95

Unit

%

MSSLogUsageWarn

Configure warning threshold for transaction log usage

Description

If the usage of the transaction log of the database exceeds the MSSLogUsageWarn threshold, but does not exceed the MSSLogUsageCrit threshold, the check status is set to Warning, unless the MSSLogExCrit threshold is exceeded.

You can define the threshold either in the 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

MSS_LOGUSAGE

Default Value

80

Unit

%

MSSUseNTLMv2

Configure database connect to use NT LAN Manager protocol version 2

Description

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

Reference Data
Configures

DBCONNECT

Default Value

0

Unit

Boolean

ORAAlertLogCountCrit

Configure critical threshold for Oracle alert log entries

Description

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

Reference Data
Configures

ORA_ALERTLOG

Default Value

1

Unit

Number

ORAAlertLogCountWarn

Configure warning threshold for Oracle alert log entries

Description

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

Reference Data
Configures

ORA_ALERTLOG

Default Value

1

Unit

Number

ORAAlertLogExprCrit

Define critical Oracle alert log entries

Description

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.

Reference Data
Configures

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
Unit

Expression

ORAAlertLogExprWarn

Define critical Oracle alert log entries

Description

Designates an entry in the Oracle alert log as warning.

Reference Data
Configures

ORA_ALERTLOG

Default Value
'%%msg%%' =~ /^ORA-0*(?:(60|1149|1555|1562)(?:\D|$))|Checkpoint not complete/i
Unit

Expression

ORAAlertLogLocation

Define the location of the Oracle alert log file

Description

Defines the location of the Oracle alert log file (fullpath, 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

ORA_ALERTLOG

Default Value
Unit

String

ORAAlertLogTimeSpan

Define Oracle alert log check period

Description

Restricts the watch period of the ORA_ALERTLOG check.

Reference Data
Configures

ORA_ALERTLOG

Default Value

60

Unit

Minutes

ORABackupSkipFilesCheck

Ignore file check of Oracle RMAN backup check

Description

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

ORA_BACKUP

Default Value

0

Unit

Boolean

ORABackupTool

Define the backup method for Oracle Databases

Description

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

ORA_BACKUP, ORA_BRARCHIVE, ORA_BRBACKUP, ORA_BRBACKUPSTAT

Default Value

BRBACKUP for the Database instance of an SAP System, RMAN for stand-alone Databases

Unit

BRBACKUP, RMAN

ORABrbackupDelayCrit

Configure critical runtime threshold for Oracle RealTime Monitoring backup checks

Description

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

Reference Data
Configures

ORA_BRBACKUPSTAT

Default Value

100

Unit

%

ORABrbackupDelayTimeCrit

Specifies a minimum critical time a BrBackup run is allowed to have.

Description

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

Reference Data
Configures

ORA_BRBACKUPSTAT

Default Value

30

Unit

Minutes

ORABrbackupDelayTimeWarn

Specifies a minimum warning time a BrBackup run is allowed to have.

Description

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

ORA_BRBACKUPSTAT

Default Value

15

Unit

Minutes

ORABrbackupDelayWarn

Configure warning runtime threshold for Oracle RealTime Monitoring backup checks

Description

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

ORA_BRBACKUPSTAT

Default Value

50

Unit

%

ORABrbackupOfflineDelayCrit

Define critical threshold for Oracle offline backup runtime

Description

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, and J2EECONNECT are set to Critical. For stand-alone Oracle Databases, the parameter is only effective if the BR*Tools are used.

Reference Data
Configures

DBCONNECT, RFCConnect, J2EECONNECT

Default Value

100

Unit

%

ORABrbackupSuccessFIDs

Configure BRBACKUP function IDs

Description

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

ORA_BRBACKUP, ORA_BRBACKUPSTAT

Default Value

ant aft

Unit

String

ORABrToolsSchema

Define schema holding BR*Tools tables

Description

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

ORA_BRARCHIVE, ORA_BRBACKUP, ORA_BRBACKUPSTAT

Default Value
Unit

String

ORABrToolsSelectRange

Restrict time period for checks based on BR*Tools operations

Description

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

Reference Data
Configures

ORA_BRARCHIVE, ORA_BRBACKUP, ORA_BRBACKUPSTAT, ORA_DBCHECKLOG

Default Value

90

Unit

Days

ORADataFileIncrementsCrit

Configure critical threshold for Oracle datafiles increments

Description

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

Reference Data
Configures

ORA_DATAFILES

Default Value

0

Unit

Number

ORADataFileIncrementsWarn

Configure warning threshold for Oracle data files increments

Description

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

Reference Data
Configures

ORA_DATAFILES

Default Value

2

Unit

Number

ORADataGuardDBCount

Configure the number of Oracle databases to monitor

Description

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

{_ORA_DATAGUARD}

Default Value

0

Unit

Number

ORADBAOperAgeCrit

Configure critical threshold for Oracle DBA operations age

Description

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

ORA_DBAOPER

Default Value

14

Unit

Days

ORADBAOperAgeWarn

Configure warning threshold for Oracle DBA operations age

Description

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

ORA_DBAOPER

Default Value

7

Unit

Days

ORADBAOperFunctionIDs

Configure functions IDs considered in ORA_DBAOPER check

Description

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

Reference Data
Configures

ORA_DBAOPER

Default Value

aly dbv opt

Unit

String

ORADBAOperSelectRange

Configure time range to watch for successful DBA operations

Description

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

Reference Data
Configures

ORA_DBAOPER

Default Value

60

Unit

Days

ORADBRemote

Configure Oracle Database for Agentless Monitoring

Description

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

ORA_ALERTLOG, ORA_BACKUP, ORA_DATAFILES, ORA_FSLOGARCH, RFCConnect

Default Value

0

Unit

Boolean

ORAEnqueueDeadLocksCrit

Defines the Critical threshold for the deadlock counter of the ORA_Enqueue Check.

Description

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

ORA_Enqueue

Default Value

1

Unit

Number

ORAEnqueueDeadLocksWarn

Defines the Warning threshold for the deadlock counter of the ORA_Enqueue Check.

Description

This 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

ORA_Enqueue

Default Value

1

Unit

Number

ORAEnqueueTimeoutsCrit

Defines the Critical threshold for the enqueue timeouts to requests ratio of ORA_Enqueue.

Description

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

ORA_Enqueue

Default Value

20

Unit

Percent

ORAEnqueueTimeoutsWarn

Defines the Warning threshold for the enqueue timeouts to requests ratio of ORA_Enqueue.

Description

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

ORA_Enqueue

Default Value

10

Unit

Percent

ORAEnqueueTimeSpan

Defines the time span during which the enqueue statistics are collected.

Description

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 is removed from the collection.

Reference Data
Configures

ORA_Enqueue

Default Value

30

Unit

Minutes

ORAEnqueueWaitsCrit

Defines the Critical threshold for the wait events to requests ratio of ORA_Enqueue.

Description

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

ORA_Enqueue

Default Value

75

Unit

Percent

ORAEnqueueWaitsWarn

Defines the Warning threshold for the wait events to requests ratio of ORA_Enqueue.

Description

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

ORA_Enqueue

Default Value

50

Unit

Percent

ORAExpSQLExclude

Exclude statements from Oracle expensive SQL check

Description

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.

Wildcard * is allowed.

Reference Data
Configures

ORA_EXPSQL

Default Value

%_T*

Unit

String

ORAExpSQLExcludeShow

Configure if excluded SQL statements are shown anyway

Description

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

Reference Data
Configures

ORA_EXPSQL

Default Value

1

Unit

Boolean

ORAExpSQLGetCrit

Configure critical threshold for Oracle buffer gets

Description

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

ORA_EXPSQL

Default Value

10

Unit

%

ORAExpSQLGetWarn

Configure warning threshold for Oracle buffer gets

Description

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

ORA_EXPSQL

Default Value

5

Unit

%

ORAExpSQLReadCrit

Configure critical threshold for Oracle physical reads

Description

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

ORA_EXPSQL

Default Value

10

Unit

%

ORAExpSQLReadWarn

Configure warning threshold for Oracle physical reads

Description

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

ORA_EXPSQL

Default Value

5

Unit

%

ORAExtentsUsageCrit

Configure critical threshold for Oracle extents usage

Description

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

ORA_SEGMENTS

Default Value

95

Unit

%

ORAExtentsUsageWarn

Configure warning threshold for Oracle extents usage

Description

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

Reference Data
Configures

ORA_SEGMENTS

Default Value

90

Unit

%

ORAFSLogArchCrit

Configure critical threshold for Oracle log arch filesystem usage

Description

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

You can define the threshold either in the 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

ORA_FSLOGARCH

Default Value

85 %

Unit

% or KB/MB/GB

ORAFSLogArchExCrit

Configure critical threshold for Oracle log arch filesystem exhaustion

Description

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

Reference Data
Configures

ORA_FSLOGARCH

Default Value

1

Unit

Hours

ORAFSLogArchExWarn

Configure warning threshold for Oracle log arch filesystem exhaustion

Description

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

Reference Data
Configures

ORA_FSLOGARCH

Default Value

12

Unit

Hours

ORAFSLogArchForecast

Enable forecasting for ORA_FSLOGARCH check

Description

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

Reference Data
Configures

ORA_FSLOGARCH

Default Value

Active

Unit

Enum (Active/Inactive)

ORAFSLogArchLocation

Configure the location of the log archive destination for the ORA_FSLOGARCH check

Description

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

ORA_FSLOGARCH

Default Value
Unit

String

ORAFSLogArchWarn

Configure warning threshold for Oracle log arch filesystem usage

Description

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.

You can define the threshold either in the 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

ORA_FSLOGARCH

Default Value

70 %

Unit

% or KB/MB/GB

ORAHomeDir

Tell the Avantra Agent where to find the Oracle Home directory

Description

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

ORARMANSelectRange

Configure time range for Oracle RMAN data

Description

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

Reference Data
Configures

ORA_BACKUP

Default Value

30

Unit

Days

ORASAPToolsEnable

Configure if or if not checks based on SAP BRCONNECT are performed

Description

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 stand-alone Database you may set this parameter as well.

Reference Data
Configures

ORA_DBAOPER, ORA_DBCHECKLOG

Default Value

Set (for Database instance of an SAP System), Not set (for stand-alone Database)

Unit

Boolean

ORASAPToolsSchema

Configure schema for BRCONNECT tables

Description

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

ORA_DBAOPER, ORA_DBCHECKLOG

Default Value
Unit

String

ORASegsChkWaitTime

Configure how often the Oracle segments check is executed

Description

Defines the time interval between two ORA_SEGMENTS checks.

Reference Data
Configures

ORA_SEGMENTS

Default Value

60

Unit

Minutes

ORASessionsCountWait

Configure count threshold of ORA_Sessions.

Description

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

ORA_Sessions

Default Value

1

Unit

Number

ORASessionsIgnoreWaitClass

Defines the wait class filter for ORA_Sessions.

Description

Configures the wait classes that shall be ignored by the ORA_Sessions Check.

The values must be separated by blanks.

Reference Data
Configures

ORA_Sessions

Default Value

Idle Configuration Concurrency

Unit

String

ORASessionsTimeWaitCrit

Defines the Critical wait time threshold for session wait times of ORA_Sessions.

Description

The check 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

ORA_Sessions

Default Value

10

Unit

Minutes

ORASessionsTimeWaitWarn

Defines the Warning wait time threshold for session wait times of ORA_Sessions.

Description

The check ORA_Sessions compares session wait times of matching sessions against this threshold to categorize them as Warning. All Warning sessions are counted and together with the Critical session count compared against ORASessionsCountWait for the final Check Result.

Reference Data
Configures

ORA_Sessions

Default Value

5

Unit

Minutes

ORATableSpaceExCrit

Configure critical threshold for tablespace exhaustion

Description

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

Reference Data
Configures

ORA_TABLESPACES

Default Value

1

Unit

Hours

Monitoring Exception Parameter available

Yes

ORATableSpaceExWarn

Configure warning threshold for tablespace exhaustion

Description

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

Reference Data
Configures

ORA_TABLESPACES

Default Value

12

Unit

Hours

Monitoring Exception Parameter available

Yes

ORATableSpaceForecast

Enable forecasting for ORA_TABLESPACES check

Description

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

Reference Data
Configures

ORA_TABLESPACES

Default Value

Active

Unit

Enum (Active/Inactive)

ORATableSpaceUsageCrit

Configure critical threshold for tablespace usage

Description

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

You can define the threshold either in the 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

ORA_TABLESPACES

Default Value

98

Unit

%

Monitoring Exception Parameter available

Yes

ORATableSpaceUsageWarn

Configure warning threshold for tablespace usage

Description

If the use of one of the database tablespaces exceeds ORATableSpaceUsageWarn percent, but none of them exceeds ORATableSpaceUsageCrit percent, the check status is set to Warning, unless the ORATableSpaceExCrit threshold is exceeded for some tablespace.

You can define the threshold either in the 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

ORA_TABLESPACES

Default Value

95

Unit

%

Monitoring Exception Parameter available

Yes

ORATNSAdminDir

Configure Oracle TNS Admin directory if not found automatically

Description

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

DBCONNECT (for Database instances of SAP Systems only)

Default Value

n/a

Unit

String

ORATNSAlias

Configure TNS alias of a Database instance of an SAP System

Description

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

DBCONNECT (for Database instances of SAP Systems only)

Default Value

n/a

Unit

String

PGSQLBloatTablePctCrit

Description

This monitoring parameter defines the critical 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

PGSQL_Bloat

Default Value

90

Unit

PCT

PGSQLBloatTablePctWarn

Description

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

PGSQL_Bloat

Default Value

5

Unit

PCT

PGSQLConnectionsUsedCrit

Description

This monitoring parameter defines the critical 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

PostgreSQL Database

Default Value

90

Unit

PCT

PGSQLConnectionsUsedWarn

Description

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

PostgreSQL Database

Default Value

80

Unit

PCT

PGSQLDeadlocksCrit

Description

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

PGSQL_Deadlocks

Default Value

600

Unit

INT

PGSQLDeadlocksWarn

Description

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

PGSQL_Deadlocks

Default Value

60

Unit

INT

PGSQLBloatIndexPctCrit

Description

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

PGSQL_Bloat

Default Value

25

Unit

PCT

PGSQLBloatIndexPctWarn

Description

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

PGSQL_Bloat

Default Value

2.5

Unit

PCT

PGSQLIdleInTransactionsCrit

Description

This monitoring parameter raises the alarm if the number of ‘idle in transaction’ sessions in PostgreSQL Database reaches the defined threshold. The parameter value can not equal or be less than the PGSQLIdleInTransactionsWarn value

Reference Data
Configures

PGSQL_LongTransactions

Default Value

5

Unit

INT

PGSQLIdleInTransactionsWarn

Description

This monitoring parameter defines the number of ‘idle in transaction’ sessions in PostgreSQL Database for the alarm to be triggered. If the number of the sessions is within the preset value, then the check result is Warning

Reference Data
Configures

PGSQL_LongTransactions

Default Value

1

Unit

INT

PGSQLLongTransactionsCrit

Description

This monitoring parameter raises the alarm if the number of long-running sessions in PostgreSQL Database reaches the defined threshold. The parameter value can not equal or be less than the PGSQLIdleInTransactionsWarn value

Reference Data
Configures

PGSQL_LongTransactions

Default Value

10

Unit

INT

PGSQLLongTransactionsWarn

Description

This monitoring parameter defines the number of long-running sessions in PostgreSQL Database for the alarm to be triggered. If the number of the sessions is within the preset value, then the check result is Warning

Reference Data
Configures

PGSQL_LongTransactions

Default Value

1

Unit

INT

PGSQLTransactionIdletime

Description

This monitoring parameter defines the length of time that a transaction needs to run before it is considered as an ‘idle in transaction’

Reference Data
Configures

PGSQL_LongTransactions

Default Value

300

Unit

SEC

PGSQLTransactionRuntime

Description

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

Reference Data
Configures

PGSQL_LongTransactions

Default Value

600

Unit

SEC

PGSQLTempFileCrit

Description

This monitoring parameter defines the critical 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

PGSQL_TempFiles

Default Value

600

Unit

INT

PGSQLTempFileWarn

Description
This monitoring parameter defines if the number of files in the temporary files storage in PostgreSQL {_Database} is higher than the preset parameter value and not higher than the {_PGSQLTempFileCrit} parameter value. If the number of temp files is within these limits, then the check result is Warning
Reference Data
Configures

PGSQL_TempFiles

Default Value

60

Unit

INT

PGSQLReplicationSlotLagCrit

Description

This monitoring parameter defines the critical 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

PGSQL_ReplicationSlot

Default Value

16

Unit

MB

PGSQLReplicationSlotLagWarn

Description

This monitoring parameter configures the Warning threshold for replication slot lag. If the lag of a replication slot goes above or equals this parameter value but not above the PGSQLReplicationSlotLagCrit, the check result is Warning.

Reference Data
Configures

PGSQL_ReplicationSlot

Default Value

1

Unit

MB

PerfDataCollection

Turn Performance Data Collection on or off (for Servers)

Description

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

System

Default Value

On

Unit

Check box

PredictiveAnalyticsEngine

Configures the Predictive Analytics engine for the Database

Description

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

  • 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

HDB_CPULoad

RelevantDailyCheckDetails

Configure Daily Check contributing check details (for Databases)

Description

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

Daily Checks

Default Value
Unit

List of Checks

RunDailyCheckOnWE

Define if Daily Checks are executed during weekend (for Databases)

Description

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

Reference Data
Configures

Daily Checks

Default Value

0

Unit

Boolean

SIQBackupSelectRange

Configure the time range for Sybase IQ Backups

Description

SIQ_Backup looks for SIQBackupSelectRange 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

SIQ_Backup

Default Value

60

Unit

Days

FullBackupAgeCrit

Configure critical threshold for maximum Full backup age

Description

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

SIQ_Backup

Default Value

14

Unit

Days

Monitoring Exception Parameter

Yes

FullBackupAgeWarn

Configure warning threshold for maximum Full backup age

Description

If the last successful FullBackup is older than FullBackupAgeWarn 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

SIQ_Backup

Default Value

7

Unit

Days

Monitoring Exception Parameter

Yes

RUNJSAllowDBWrite

Allows SQL queries executed as part of custom checks and workflows, to change data within the Database

Description

RunJSAllowDBWrite 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.

Reference Data
Configures

RUN_JS

Default Value

Disabled

Unit

Boolean

SIQDataFilesUsageCrit

Configure the Critical threshold for SAP Sybase IQ dbfile usage check SIQ_DataFiles

Description

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

You can define the threshold either in the 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

SIQ_DataFiles

Default Value

95%

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

SIQDataFilesUsageWarn

Configures the Warning threshold for SAP Sybase IQ dbfile usage check SIQ_DataFiles

Description

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

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

SIQ_DataFiles

Default Value

80%

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

SIQConnectionsNumCrit

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

Reference Data
Configures

SIQ_Connections

Default Value

2

Unit

Number

SIQConnectionsNumWarn

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

Reference Data
Configures

SIQ_Connections

Default Value

5

Unit

Number

SIQMainCacheUsageCrit

If Main Cache Usage goes above this parameter value, the check result is CRITICAL.

Reference Data
Configures

SIQ_Cache

Default Value

95%

Unit

%

SIQMainCacheUsageWarn

If Main Cache Usage goes above this parameter value and below SIQMainCacheUsageCrit parameter value, the check result is WARNING.

Reference Data
Configures

SIQ_Cache

Default Value

90%

Unit

%

SIQTempCacheUsageCrit

If Main Temp Usage goes above this parameter value, the check result is CRITICAL.

Reference Data
Configures

SIQ_Cache

Default Value

95%

Unit

%

SIQTempCacheUsageWarn

If Main Temp Usage goes above this parameter value and below SIQTempCacheUsageCrit parameter value, the check result is WARNING.

Reference Data
Configures

SIQ_Cache

Default Value

90%

Unit

%

SIQCatalogCacheUsageCrit

If Catalog Cache Usage goes above this parameter value, the check result is CRITICAL.

Reference Data
Configures

SIQ_Cache

Default Value

95%

Unit

%

SIQCatalogCacheUsageWarn

If Catalog Cache Usage goes above this parameter value and below SIQCatalogCacheUsageCrit parameter value, the check result is WARNING.

Reference Data
Configures

SIQ_Cache

Default Value

90%

Unit

%

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

SIQ_OperationsWaiting

Default Value

5

Unit

Number

SIQOperationsWaitingCrit

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

Reference Data
Configures

SIQ_OperationsWaiting

Default Value

10

Unit

Number

SIQTransactionRuntime

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

Reference Data
Configures

SIQ_LongTransactions

Default Value

60

Unit

Minutes

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

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

SIQ_LongTransactions

Default Value

5

Unit

Number

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

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

SIQ_Threads

Default Value

5

Unit

Number

SIQDataSpacesExCrit

Configure the Critical threshold for data spaces exhaustion

Description

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

Reference Data
Configures

SIQ_DataSpaces

Default Value

1

Unit

Hours

SIQDataSpacesExWarn

Configure the Warning threshold for data spaces exhaustion

Description

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

Reference Data
Configures

SIQ_DataSpaces

Default Value

12

Unit

Hours

SIQDataSpacesForecast

Enable forecasting for SIQ_DataSpaces check

Description

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

Reference Data
Configures

SIQ_DataSpaces

Default Value

Active

Unit

Enum (Active/Inactive)

SIQDataSpacesUsageCrit

Configure the Critical threshold for Sybase IQ dataspaces usage check SIQ_DataSpaces

Description

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

You can define the threshold either in the 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

SIQ_DataSpaces

Default Value

95%

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

SIQDataSpacesUsageWarn

Configure the Warning threshold for Sybase IQ dataspaces usage check SIQ_DataSpaces

Description

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

You can define the threshold either in the 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

SIQ_DataSpaces

Default Value

80%

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

SYBBackupExclude

Exclude databases from SYB_Backup check

Description

Comma-separated list of database names that are ignored from the SYB_Backup check. 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. However, you may add more databases since the backup of some databases is documented as optional in official SAP guide SAP Business Suite on SAP Adaptive Server Enterprise.

Reference Data
Configures

SYB_Backup

Default Value

model, saptempdb, sybsecurity, sybsystemdb, sybsystemprocs, tempdb

Unit

String

SYBBackupSelectRange

Configure the time range for Sybase ASE Backups

Description

SYB_Backup looks for SYBBackupSelectRange 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

SYB_Backup

Default Value

60

Unit

Days

SYBBackupOKDisplayMax

Description

Defines how many successful backups will be displayed in the table of SYB_Backup check. 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

SYB_Backup

Default Value

5

Unit

Number

SYBBackupStatDelayTimeCrit

Specify a minimum Critical runtime a currently running backup is allowed to have

Description

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

Reference Data
Configures

SYB_BackupStat

Default Value

30

Unit

Minutes

SYBBackupStatDelayTimeWarn

Specify a minimum Warning runtime a currently running backup is allowed to have

Description

If the running time of a Sybase backup is above 50 percent of the usual average runtime and above SYBBackupStatDelayTimeWarn minutes, the check status is set to Warning, unless the Critical conditions are met, see SYBBackupStatDelayTimeCrit.

Reference Data
Configures

SYB_BackupStat

Default Value

15

Unit

Minutes

SYBBackupStatExclude

Exclude databases from SYB_BackupStat check

Description

Comma-separated list of database names that are ignored from the SYB_BackupStat check. 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. However, you may add more databases since the backup of some databases is documented as optional in official SAP guide SAP Business Suite on SAP Adaptive Server Enterprise.

Reference Data
Configures

SYB_BackupStat

Default Value

model, saptempdb, sybsecurity, sybsystemdb, sybsystemprocs, tempdb

Unit

String

SYBBackupStatFailedStatus

Description

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

Reference Data
Configures

SYB_BackupStat

Default Value

Warning

Unit

Enum

SYBBackupStatFailedDisplayTime

Description

Defines the time how long a failed backup is displayed (status is defined by SYBBackupStatFailedStatus). SYBBackupStatFailedDisplayTime minutes after the failed backup has been detected, the check result status is reset to Ok.

Reference Data
Configures

SYB_BackupStat

Default Value

60

Unit

Minutes

SYBDBExCrit

Configure Critical threshold for data spaces exhaustion

Description

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

Reference Data
Configures

SYB_DataSpaces

Default Value

1

Unit

Hours

SYBDBExWarn

Configure Warning threshold for data spaces exhaustion

Description

If the predicted point in time when the data space is exceeded is within the upcoming SYBDBExWarn hours, but not within the upcoming SYBDBExCrit hours, the check status of SYB_DataSpaces is set to Warning, unless the SYBDBUsageCrit threshold is exceeded.

Reference Data
Configures

SYB_DataSpaces

Default Value

12

Unit

Hours

SYBDBUsageCrit

Configure the Critical threshold for Sybase ASE data space usage check SYB_DataSpaces

Description

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

You can define the threshold either in the 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

SYB_DataSpaces

Default Value

95 %

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

SYBDBUsageWarn

Configure the Warning threshold for Sybase ASE data space usage check SYB_DataSpaces

Description

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

You can define the threshold either in the 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

SYB_DataSpaces

Default Value

80 %

Unit

% or KB/MB/GB

Monitoring Exception Parameter available

Yes

SYBDBForecast

Enables forecasting for SYB_DataSpaces check

Description

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

Reference Data
Configures

SYB_DataSpaces

Default Value

Active

Unit

Enum (Active/Inactive)

SYBErrorLogTimeSpan

Configures time span to look back for SYB_ErrorLogStat

Description

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

Reference Data
Configures

SYB_ErrorLogStat

Default Value

60

Unit

Minutes

SYBErrorLogExcludeErrNums

Exclude error numbers from check evaluation

Description

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

SYB_ErrorLog, SYB_ErrorLogStat

Default Value

n/a

Unit

String

SYBLogBackupExclude

Exclude databases from SYB_LogBackup check

Description

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

SYB_LogBackup

Default Value

master, model, saptempdb, saptools, sybmgmtdb, sybsecurity, sybsystemdb, sybsystemprocs, tempdb

Unit

String

SYBLogBackupAgeCrit

Configures the Critical threshold for Sybase ASE log backup age check SYB_LogBackup

Description

If the last transaction log dump is above SYBLogBackupAgeCrit minutes ago, the check result is Critical.

Reference Data
Configures

SYB_LogBackup

Default Value

120

Unit

Minutes

SYBLogBackupAgeWarn

Configures the Warning threshold for Sybase ASE log backup age check SYB_LogBackup

Description

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

Reference Data
Configures

SYB_LogBackup

Default Value

60

Unit

Minutes

SYBLogExCrit

Configure Critical threshold for log spaces exhaustion

Description

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

Reference Data
Configures

SYB_LogSpaces

Default Value

1

Unit

Hours

SYBLogExWarn

Configure Warning threshold for log spaces exhaustion

Description

If the predicted point in time when the log space is exceeded is within the upcoming SYBLogExWarn hours, but not within the upcoming SYBLogExCrit hours, the check status of SYB_LogSpaces is set to Warning, unless the SYBLogUsageCrit threshold is exceeded.

Reference Data
Configures

SYB_LogSpaces

Default Value

12

Unit

Hours

SYBLogForecast

Enable forecasting for SYB_LogSpaces check

Description

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

Reference Data
Configures

SYB_LogSpaces

Default Value

Active

Unit

Enum (Active/Inactive)

SYBLogUsageCrit

Configure the Critical threshold for Sybase ASE data space usage check SYB_LogSpaces

Description

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

You can define the threshold either in the 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

SYB_LogSpaces

Default Value

95 %

Unit

% or KB/MB/GB

SYBLogUsageWarn

Configure the Warning threshold for Sybase ASE log space usage check SYB_LogSpaces

Description

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

You can define the threshold either in the 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

SYB_LogSpaces

Default Value

80 %

Unit

% or KB/MB/GB

SYB_FullBackupAgeCrit

Configures the critical threshold for maximum backup age

Description

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 FullBackupAgeCrit days. You can define overriding this value on a per-day level using the corresponding {_Monitoring Exception Parameter}.

Reference Data
Configures

SYB_Backup

Default Value

7 (overtake value from already configured BackupAgeCrit)

Unit

Day

SYB_FullBackupAgeWarn

Configures the warning threshold for maximum backup age

Description

This monitoring parameter checks the database against dump_type DATABASE (full) and CUMULATIVE (incremental). If the last successful backup is older than FullBackupAgeWarn 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 Exception Parameter}.

Reference Data
Configures

SYB_Backup

Default Value

1 (overtake value from already configured BackupAgeWarn)

Unit

Day

TimeOutDBMonitor

Configure timeout for Database connect check

Description

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

Reference Data
Configures

DBCONNECT

Default Value

180

Unit

Seconds

StartStopDependentWINService

Used in Automation for Windows operating systems.

Description

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
Default Value

not set

Unit

Boolean