Database - Built-in Checks

Checks the end date / time of the most recent backup required for complete recovery of the Database.

If it is older than a configured period of time, a Warning or a Critical message is generated.

The maximum allowed age can be defined generally by using parameters BackupAgeCrit and BackupAgeWarn and the corresponding Monitoring Exception Parameters.

Additionally, the check displays an overview of all backups required for the most recent complete Database recovery.

An alarm is raised if the data area usage exceeds some configurable threshold, or if the predicted data area exhaustion is within a configurable period of time.

An alarm is raised if the log area usage exceeds some configurable threshold, or if the predicted log area exhaustion is within a configurable time period.

Checks for backup maintenance plans and verifies if they were successfully executed.

If no backup maintenance plan for full backup is found, the check status will be Critical and there will be no further check evaluation.

If there is a full backup maintenance plan, the reports of this plan will be evaluated. ANY_Backup collector will select reports of the last ANYBackupSelectRange days. For the backup check to be Ok, a successful report must be found, and the finished time of the last full backup must be below thresholds ANYBackupFullWarnAge and ANYBackupFullCritAge.

Additionally, the age of the last successful backup must be below BackupAgeWarn and BackupAgeCrit, but it is not required that the last successful backup is a full backup. If the latest backup was unsuccessful, the check status will be Warning unless Critical thresholds are exceeded.

An alert is raised if the number of database connections exceeds some configurable threshold. In case the number defined in Avantra threshold ANYConnectionsNumCrit is above the number of connections allowed (SAP SQL Anywhere database option max_connections), the defined thresholds ANYConnectionsNumCrit and ANYConnectionsNumWarn will be automatically adapted to 95 % and 80 % of the max_connections value.

An alert is raised if dbspace usage exceeds some configurable threshold, or if the predicted dbspace exhaustion is within a configurable period of time. Exceptions to the general Warning and Critical thresholds may be defined on a per dbspace level.

The check queries for server messages within the last day. If Monitoring Parameter RunDailyCheckOnWE is false, the check queries for server messages for the last 3 days on Mondays, to make sure you do not miss any entries.

The check status is Ok if only INFO messages are found or the number of ERR and WARN messages is below ANYMessagesNumWarn. If the number of both, ERR and WARN messages is above ANYMessagesNumWarn the check status is Warning, unless the number of ERR messages is exceeding ANYMessagesNumCrit which will result in Critical check status.

It is possible to exclude messages from being counted as WARN or ERR messages. To do so, please use Monitoring Parameter ANYMessagesExclude, see the parameterʼs documentation for the syntax details.

ANY_MessagesStat does the same as ANY_Messages — monitoring the SAP SQL Anywhere server messages, but queries it for entries within last ANYMessagesStatTimespan minutes only and reports to RealTime Monitoring.

Determines the databaseʼs transaction and possible mirror transaction log and checks the usage of the same. An alert is raised if log usage exceeds some configurable threshold, or if the predicted transaction log exhaustion is within a configurable period of time.

Checks the last full database backup and shows its start, end and runtime.

If it was not successful a Warning or Critical status is reported, depending on the exit state of the latest backup command.

Additionally, the age of the last successful backup is checked. If the last successful backup is too old a Warning is reported. The maximum age can be defined using the Monitoring Parameters BackupAgeCrit and BackupAgeWarn. There is also the option to define a Monitoring Exception Parameter.

The return code of the latest backup is evaluated.

If the return code is 0, the check status will be Ok, in case the value is 1, the status will be Warning. Otherwise, the status is set to Critical.

This check reports to the RealTime Monitoring, The Monitoring Parameter BackupResetRTMTime can be used to reset the check status back to Ok automatically after a certain period of time.

Counts the number of tables / indexes with statistics not older than DB2CBOMaxAge days.

If the number of tables / indexes with up-to-date statistics is below threshold DB2CBONumEntriesUpdCrit or DB2CBONumEntriesUpdWarn the check will return a Critical or a Warning message.

See Monitoring Parameter ABAPDBSchema if you need to override the schema name for this Check.

An alert is raised if a certain number of entries with a Warning, Error, or Severe value in the Level property are found during a configurable period of time.

The DB2_DIAGLOG check can be configured in a very flexible way. The log parsing engine allows you to access any field of a DB2 diagnostics log entry, and you have the option to define virtually any Boolean expression in order to consider certain entries as Warning or Critical.

The check evaluation rule is: If there are more than DB2DiagLogCountCrit entries found during the past DB2DiagLogTimeSpan minutes matching the expression DB2DiagLogExprCrit, the check status will be Critical. Otherwise, if there are more than DB2DiagLogCountWarn entries during the same time span matching the expression DB2DiagLogExprWarn, the check status will be Warning. Otherwise, it will be Ok.

The location of the DB2 diagnostics log file is determined by the diagpath DB2 Database parameter. In case diagpath is not set, the check returns a Warning.

The DB2_DIAGLOG check is not supported for systems using a remote database (i.e. if DB2DBRemote is set to 1)!

Reports expensive SQL statements considering the I/O of all statements in query cache.

An SQL statement is considered expensive if the amount of logical and/or physical reads for the particular statement exceeds a certain amount of all logical and physical reads.

Warning and Critical thresholds can be defined for the logical and physical reads, and statements can be excluded from the check.

The check execution depends on the configuration of your DB2 UDB Database.

The DB2_FSLOGARCH check is not supported for systems using a remote database (i.e. DB2DBRemote is set to 1).

An alert is raised if the log space of the DB2 UDB Database exceeds some configurable threshold, or if the predicted log space exhaustion is within a configurable period of time.

An alert is raised if tablespace usage exceeds some configurable threshold, or if the predicted tablespace exhaustion is within a configurable period of time. Exceptions to the general Warning and Critical thresholds may be defined on a per tablespace level.

Auto-resize tablespaces are supported as well. The check considers the space available assuming that the tablespace can be resized to its limit regardless of any underlying file system limitations. If a tablespace is configured with the "unlimited" maximum size (i.e. tablespace_max_size is -1), the architectural size limit of the tablespace is considered (see also DB2 LUW SQL and XML Limits).

You can distinguish auto-resized tablespaces from other ones in the Check Result. If a tablespace is configured using auto-resize, you will get the following result in case of a Warning or Critical check status:

Since — in the example above — the amount of actual free space in the tablespace is identical to the maximum available auto-resize free space the tablespace will not extend any further and it might be time to reorganize or to upgrade to large tablespaces.

The following example shows the situation where a tablespace still can be auto-resized:

Verifies the connection to a Database. If the Database connection has been established successfully, the check will provide some additional information in its result.

If the Database connection fails, the Check Result will be Warning and after DBConnectErrsCrit subsequent connection attempts without success, the result will be Critical.

Additionally, the check serves as a overview check for all other checks executed on a Database, so if the connection fails, all the other dependent checks will return Unknown.

The DBCONNECT check therefore is the most important check for a Database.

Returns the overall status of all Checks executed during the Daily Check on a particular SAP Instance or Database.

For instance, if the connection attempt (to the SAP Instance or Database) failed, this check type returns a Critical message. If this check fails, all other dependent checks will have status Unknown.

In the Ok status, the check explains what checks were executed for a particular SAP Instance or Database, which profiles were collected, etc.

You may want to skip the execution of Daily Checks on the weekend using Monitoring Parameter RunDailyCheckOnWE.

Verifies that no entries have been written to M_ADMISSION_CONTROL_EVENTS during the last HDBAdmissionTimeSpan minutes. For more information on Admission Control see SAP Note 2222250.

Monitors the alerts generated by the statistics server. The alerts are counted according to their priority: Error, High, Medium, and Low.

The check status is set to Warning if at least one alert with priority Error or High is found within the timespan defined by HDBAlertsTimeSpan. If the number of Error alerts is above HDBAlertsErrorCountCrit or the number of High alerts is above HDBAlertsHighCountCrit the check status is set to Critical.

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, or if the number of alerts with rating Low found within the timespan defined by HDBAlertsTimeSpan is equal to or above HDBAlertsLowCountWarn.

The check status for HDB_Alerts will be Ok if no alerts with priority above Medium are found, and the number of Medium priority alerts is below the HDBAlertsMediumCountWarn threshold and the number of Low priority alerts is below the HDBAlertsLowCountWarn threshold.

Finally, 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' 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.

If the latest complete backup was not successful a Warning check status is generated.

If the latest successful complete backup is older than BackupAgeCrit a Critical check status is generated, if it is older than BackupAgeWarn the check status will be Warning.

If no complete backups are found in the time range defined by HDBBackupCompleteSelectRange the check status will be Critical.

This Check returns the average host CPU over the last time interval configured by monitoring parameter HDBCPULoadAverageTime and compares it against the threshold parameters set. It also returns the Process CPU Load, but this is not used in the check logic.

In the Avantra Enterprise Edition this check supports Predictive Analytics.

This Check monitors the duration of Delta Merges. The check status turns to Warning or Critical if there is a certain number of delta merges exceeding the corresponding runtime thresholds.

This Check verifies the usage of the filesystems (disks) used to store the HANA Database data (i.e. storage devices). You may exclude storage devices by using the exclude parameters listed below. For example, log backup storage devices might be reported with zero size since they are backed up by a 3rd party backup solution.

A special case of the HDB_Disks Check for the SAP HANA Log Areas with more restrictive thresholds.

A special case of the HDB_Disks Check for the SAP HANA Log Backups with more restrictive thresholds.

An SQL statement is considered expensive if its total execution time compared to the total execution time of all SQL statements exceeds a given threshold.

This check monitors the duration of jobs running on SAP HANA. If jobs are found which are running longer than HDBJobRuntimeCrit minutes, the status of the check will be Critical. If jobs are found, which are running longer than HDBJobRuntimeWarn but still not longer than HDBJobRuntimeCrit minutes, the status will be Warning.

You may exclude jobs from being verified by using HDBJobNameExclude. Per default jobs with name Backup are excluded.

This Check monitors the status of the different SAP HANA hosts. It is specially useful in scale-out environments to detect switchover situations to the standby host.

The Check Result is Ok as long as all hosts are active and all host’s status is either OK or IGNORE. Otherwise, the Check will turn to the check status defined in HDBLandscapeSeverity.

The check verifies the type of the installed license. As long as a temporary license is installed, the check is Critical and the customer is pleased to install a real license. It verifies the validity of the license. If a valid license is found, the expiration is monitored. Furthermore, the difference between the peak memory usage and the licensed memory amount is monitored as well.

Checks for successful / failed log backups in the past hour or a time span configurable by HDBLogBackupTimeSpan. The check will become Critical when there are only failed backups found during the time span, otherwise, it will be Warning. If there are at least one successful and no failed backups found during the time span, the check will be Ok.

Various reasons may cause a HANA log file to be locked. This check verifies the number of locked log files and raises an alert if there are too many locked log files.

Compares the database peak memory usage (since the last reset) to the allocation limit.

Monitors the physical memory ( ) usage on each host.

Monitors the service memory usage. Compares the memory used against the effective allocation limit.

Verifies the SAP HANA operational status i.e. if all services are started.

The check status is Ok if all services are active.

The check turns to Critical if no services are found or if at least one service is not active.

In a HANA replication scenario, this check checks the replication delay between the primary and secondary sides.

The check will not be present on HANA systems without a replication scenario.

Verifies, if the HANA database has replicated services and if yes, checks if all secondary services are active, fully recoverable, and the replication status is active.

If the HANA database is not configured for system replication, the status of HDB_SystemReplication is Ok per default. You can change this behavior by using HDBSystemReplNotFoundStatus, which allows you to define another status if system replication is not found.

If there are replicated services found, the check status is Ok if all the following conditions are met:

The check turns to Critical if one of the upper conditions is not met. In this case, please observe possible detailed information in column Repl. Status Details.

This check verifies the status of the user SYSTEM in the HANA database. If the user SYSTEM is deactivated, the check is Ok. As long as the user SYSTEM is active (usable), the check is Warning. In case the user SYSTEM is deleted, the check is Critical.

Monitors the behavior of the total memory pools listed below in relation to the global allocation limit:

This check verifies how much memory in % these pool sizes use from the defined global allocation limit. According to the parameters, the check turns to Warning or even to Critical.

Identify tables partition approaching the upper limit of the 2 bn rows. As long as the amount of the partitioned table rows is low enough, the check is Ok. According to the parameters, the check turns to Warning or even Critical.

Compares the database tenant peak memory usage (since the last reset) to the allocation limit.

Checks the latest backup date / time of the SAP SID, master and msdb Database.

If the latest backup is older than a configured period of time, a Warning message is generated. For the SAP SID Database this period of time can be configured separately for each weekday.

Calculates the amount of used space in the managed Database. An alert is raised if the used space exceeds some configurable threshold, or if the predicted space exhaustion is within a configurable period of time.

Reports expensive SQL statements considering the I/O of all statements in query cache.

An SQL statement is considered expensive if the amount of logical and/or physical reads for the particular statement exceeds a certain amount of all logical and physical reads.

Warning and Critical thresholds can be defined for the logical and physical reads, and statements can be excluded from the check.

Determines the last transaction log backup of the managed Database.

If it is older than the configurable Warning or Critical thresholds an alert is raised respectively.

If you are using the simple recovery model you may want to disable this Check.

Determines the usage of the transaction log for the managed Database. An alert is raised if the transaction log usage exceeds some configurable threshold, or if the predicted exhaustion is within a configurable period of time.

Verifies the Oracle alert log file.

A Critical alert is raised if a certain number of the following entries is found during a configurable period of time:

A Warning alert is raised if a certain number of the following entries is found:

The ORA_ALERTLOG check can be configured in a very flexible way. The log parsing engine allows you to access any field of an Oracle alert log entry, and you have the option to define virtually any Boolean expression in order to flag certain entries as Warning or Critical.

The check evaluation rule is: If there are more than ORAAlertLogCountCrit entries found during the past ORAAlertLogTimeSpan minutes matching the expression ORAAlertLogExprCrit, the check status will be Critical. Otherwise, if there are more than ORAAlertLogCountWarn entries during the same time span matching the expression ORAAlertLogExprWarn, the check status will be Warning. Otherwise, it will be Ok.

The location of the Oracle alert log file is determined by the server Monitoring Parameter ORAAlertLogLocation. If this parameter is not set, the value from the DIAGNOSTIC_DEST (for Oracle 11g and newer) or BACKGROUND_DUMP_DEST (Oracle 10g and older) parameter is considered.

A Warning Check Result will be returned if the location cannot be determined.

The ORA_ALERTLOG check is not supported for systems using a remote database (i.e. ORADBRemote is set to 1)!

This check verifies the availability and consistency of the latest backup performed with the Oracle Recovery Manager (RMAN).

The check is only executed if parameter ORABackupTool is set to RMAN which is the default for stand-alone Databases.

If your database is backed up with SAP BR*Tools, you should set ORABackupTool to BRBACKUP (default for SAP System. In this case, this check is automatically deleted.

If you neither use RMAN nor the BR*Tools to backup your Oracle Database you are encouraged to disable this check.

Basically, a backup is considered available and consistent if it can be recovered by`RMAN`. So the check verifies if the control file, spfile, datafiles, and archive log files backups are consistent and if the point in time they can be recovered to is not older than defined in the Monitoring Parameters BackupAgeWarn or BackupAgeCrit. Otherwise, the check will report a corresponding Warning or Critical Check Result.

The consistency check of the backups comprises the verification of consistent`SCN`(System Change Numbers, Transaction Numbers) chains contained in valid incremental backups starting with a valid full backup.

The latest SCN of the newest complete incremental backup chains of the datafiles are searched for in the Redo Log Backup Sets, and starting from the oldest set, the Redo Log Backup _SCN_s are checked for consistency up to the last entry.

For further information on Backup Sets and SCNs, see the Oracle RMAN documentation.

If backups are written to disk, the check also verifies if the files are available on disk, unless parameter ORABackupSkipFilesCheck is set, or the database is monitored remotely (indicated by parameter ORADBRemote). The Avantra Agent needs the appropriate permissions on the file system to verify the existence of the files. Set the ORABackupSkipFilesCheck otherwise.

The check will return Critical also if no backup is found within the period defined by ORARMANSelectRange.

An overview of all BrArchive runs during the last Full Check Cycle is listed in the Check Result.

If there are unsuccessful runs the check will result in a {Warning}. The check is only executed if parameter ORABackupTool is set to BRBACKUP which is the default for an SAP System. If your database is not backed up with SAP BR*Tools, but with _RMAN, you should set ORABackupTool to RMAN (default for stand-alone Databases). In this case, this check is automatically deleted.

If you neither use RMAN nor the BR*Tools to backup your Oracle Database you are encouraged to disable this check.

This check type comprises two different sub-checks:

The check is only executed if parameter {ORABackupTool} is set to BRBACKUP which is the default for SAP System. If your database is not backed up with SAP BR*Tools, but with _RMAN, you should set ORABackupTool to RMAN(default for stand-alone Databases). In this case, this check is automatically deleted.

If you neither use RMAN nor the BR*Tools to backup your Oracle Database you are encouraged to disable this check.

This check type comprises two different sub-checks:

The check is only executed if parameter {ORABackupTool} is set to BRBACKUP which is the default for SAP System. If your database is not backed up with SAP BR*Tools, but with _RMAN, you should set ORABackupTool to`RMAN`(default for stand-alone Databases). In this case, this check is automatically deleted.

If you neither use RMAN nor the BR*Tools to backup your Oracle Database you are encouraged to disable this check.

This check reports to the RealTime Monitoring. The parameter BackupResetRTMTime can be used to reset the check status back to Ok automatically after a certain period of time.

This check comprises two sub-checks:

This check is implemented under particular parameters, which checks on the Oracle Dataguard feature (High Availability/Disaster Recovery) for Oracle databases with eight sub-checks to ensure archive destinations fulfill specific criteria.

By default, this check is disabled for all customers and should not report back ever any results.

This check verifies certain Oracle DBA operations that are executed with BR*Tools.

The operations can be selected by defining their Function IDs (e.g. as listed in transaction DB14) in ORADBAOperFunctionIDs.

The check is only executed if the Monitoring Parameter ORASAPToolsEnable is set to 1, which is the default for SAP Systems. For stand-alone Databasesthis check is by default disabled, i.e. ORASAPToolsEnable is set to 0. If you enable the check you probably have to set the Monitoring Parameter ORASAPToolsSchema as well.

The check consists of two sub-checks: * The return code of the latest finished DBA operation is checked. If the return code is 0, the check status will be Ok, if it is 1, the check status will be Warning, otherwise, the check status will be Critical. Running operations with RC=9999 are ignored. * It is verified if the latest successful DBA operation is not older than defined in the ORADBAOperAgeCrit or ORADBAOperAgeWarn thresholds. Otherwise, the check status will be set accordingly.

By default, the following operations are checked: * Collect Optimizer Statistics * Database verification with DBVERIFY * Check Optimizer Statistics

See also the description of the Monitoring Parameter ORADBAOperFunctionIDs.

The result of the latest sapdba -check or brconnect -f check run is parsed. If the last run is older than 24 hours, a Warning message is raised. Data is only searched for in the time span defined by ORABrToolsSelectRange.

Otherwise, the result is not too old. It is analyzed as follows: if the result contains messages with W level, the check returns a Warning, if the result contains messages with E level, the check returns Critical.

The check is only executed if the Monitoring Parameter ORASAPToolsEnable is set to 1, which is the default for SAP Systems. For stand-alone Databasesthis check is by default disabled, i.e. ORASAPToolsEnable is set to 0. If you enable the check you probably have to set the Monitoring Parameter ORASAPToolsSchema as well.

This Check collects enqueue statistics on timeouts, waits, and deadlocks. The statistics are temporarily stored with a timestamp. The Check then verifies if the statistics values exceed one of the defined thresholds in a certain time span.

For deadlocks, absolute numbers are collected and verified. As Oracle recommends examining each deadlock, the default Critical threshold for deadlocks is set to 1.

Timeouts and waits are calculated as a ratio to the total number of enqueue requests and conversions. This allows the Check to scale on huge Databases, where more enqueue requests will occur, resulting in more timeouts and wait events.

All thresholds can be configured by means of Monitoring Parameters. For each statistics value there are two separate thresholds for Warning and Critical check status available. By default, the Warning thresholds are disabled, i.e. they have the same default value as their corresponding Critical threshold. The threshold parameters are: ORAEnqueueDeadLocksCrit/ORAEnqueueDeadLocksWarn, ORAEnqueueTimeoutsCrit/ORAEnqueueTimeoutsWarn, ORAEnqueueWaitsCrit/ORAEnqueueWaitsWarn.

By setting a Critical threshold to 0 (or < 0), the associated statistics check is turned off; e.g. setting ORAEnqueueTimeoutsCrit to 0 disables the timeouts part of the check.

The time span by which the statistics are collected and verified can be configured using the ORAEnqueueTimeSpan Monitoring Parameter.

An SQL statement is considered expensive if the amount of buffer-gets and disk-reads for the particular statement exceeds a certain amount of all buffer-gets and disk-reads. Warning and Critical thresholds can be defined for the gets and reads, and programs executing the statements can be excluded from the check.

A special case of the FILESYSTEMS check for ORAARCH filesystems with separate thresholds.

The ORAARCH filesystems are detected automatically. This check is not supported for remote databases (i.e. ORADBRemote is set to 1).

This check verifies if the Database runs in archive log mode and returns Critical if not.

The check analyzes the Oracle segments (e.g. tables and indexes) of tablespaces with dictionary extent management and permanent storage in two ways:

For databases with locally managed tablespaces only, the Check Result simply displays a message:

If the check status is Ok, and if the database contains dictionary extent management tablespaces, the check will display the covered tablespaces:

This Check counts the number of waiting sessions, considering wait time, wait class, and wait status of each session.

For each session waiting and holding a matching wait class (at time of Check execution), the wait time is compared against a Warning and a Critical wait time threshold (Monitoring Parameters ORASessionsTimeWaitWarn and ORASessionsTimeWaitCrit). All Warning and Critical sessions are counted, and the counter is compared against a count threshold (Monitoring Parameter ORASessionsCountWait). If the count threshold is exceeded by the Critical sessions, the check will be Critical, otherwise, if the count threshold is exceeded by the Critical and Warning sessions, the check will be Warning.

The wait class of a session is considered to filter out sessions not accounting for the check status. The wait class filter can be configured by means of the ORASessionsIgnoreWaitClass Monitoring Parameter.

An alert is raised if the tablespace usage exceeds some configurable threshold, or if the predicted tablespace exhaustion is within a configurable period of time.

Exceptions to the general Warning and Critical thresholds may be defined on a per tablespace level.

For tablespaces with auto-extent enabled, the maximum allocatable space (in the check message labeled auto-extent free) is considered as free space for usage and remaining free space calculations, and not the real free space (labeled`free`) considering the currently allocated tablespace size.

The details about exhausted tables are only shown when:

This check retrieves the information from the PostgreSQL database about tables and indexes that have significant bloat (disk space used before a table/index update that is now no longer needed and can be released as free space). If the bloat percentage per database is within or beyond the preset thresholds, the status of the check changes. The monitoring parameters are used to customize the bloat percentage value that is required to trigger a certain check status.

This check executes a query to retrieve the information from the PostgreSQL Database about the available and used connections to the Database. If the ratio of active user connections is within or beyond the preset thresholds, the status of the check changes. The monitoring parameters are used to customize the percentage of active user connections required to trigger a certain check status.

This check executes a query to retrieve this information from the PostgreSQL database. The total number of deadlocks since the last PostgreSQL statistics reset is shown as well as the number of deadlocks that occurred in the last hour or since the Avantra agent restarted (whichever is earlier). The monitoring parameters can be used to customize the number of deadlocks that are required (in this time period) to trigger a certain check status.

This check executes a query to retrieve the information from the PostgreSQL database about the long-running transactions and sessions that stay in the "idle in transaction" state for too long. The check result shows if there are too many active transactions running longer than the defined threshold or if there are "idle" transactions running longer than the preset threshold. If the number is above the predefined thresholds, the system raises the alert. The monitoring parameters can be used to customize the time threshold for different types of transactions.

This check keeps track of the lag status of replication slots on a PostgreSQL Database and raises the alert if a replication slot gathered warning or critical amount of replication lag.

This check executes a query to retrieve the information from the PostgreSQL Database about the number of temporary files. The total number of files in temporary file storage since the last PostgreSQL statistics reset is shown. If this number is above the predefined thresholds, the system alert is raised. The monitoring parameters can be used to customize the number of temp files in the storage that is required (in this period) to trigger a certain check status.

The check verifies if the last backup for each database was successful. If the last backup has failed, the check result will be Warning.

Then the check looks for the last successful backup of the database. If there is none at all (at least none in SIQBackupSelectRange days) or if the time since the last dump is above threshold BackupAgeCrit, the check result will be Critical.

If there is a successful backup and the time since the last backup is below BackupAgeCrit but above SIQBackupAgeWarn the check result will be Warning.

The check verifies if enough free space is available in all datafiles. If the usage or the amount of remaining free space is exceeding/falling below SIQDataFilesUsageCrit the check status will be Critical. If the usage or the amount of remaining free space is exceeding/falling below SIQDataFilesUsageWarn but is still below/above SIQDataFilesUsageCrit, the status will be warning.

The total check status is the worst of all sub-status of all datafiles. You can see the sub-result for each datafile in the table provided. This checks features Monitoring Exception Parameters, so you may define individual thresholds for certain databases.

The check retrieves current database connection figures and evaluates a number of free connections, that is, the number of connections the database can accept additionally. The more available connections, the better.

If the evaluated figure falls below or equals SIQ_ConnectionsWarn, but is more than SIQConnectionsCrit, the check result is WARNING. If the evaluated figure is less than or equals SIQConnectionsCrit, the check result is CRITICAL.

The check queries the database to get information on the Main, Temp and Catalog Cache sizes, and their usages. There is a sub-check per cache (main, temp and catalog).

For the Main cache, by default we only enable the WARNING status as this check alerts if there is too much free space allocated to the main cache that could indicate a cache rebalance is necessary. It is possible to also configure a CRITICAL threshold if desired.

For the Temp and Catalog checks, we check the reverse, whether these caches are running out of space with WARNING and CRITICAL threshold configured for both by monitoring parameter (SIQ<cache_name>CacheUsageWarn and SIQ<cache_name>CacheCrit).

The check retrieves all the transactions currently running and counts ones running longer than the time specified with SIQTransactionRuntime. The fewer long-running transactions are there, the better.

If the evaluated figure exceeds or equals SIQLongTransactionsWarn, but is less than SIQLongTransactionsCrit, the check result is WARNING. If the evaluated figure is more than or equals SIQLongTransactionsCrit, the check result is CRITICAL.

During the check, a number of operations waiting for the resource governor is evaluated. The fewer operations are in the queue, the better

If the evaluated figure exceeds or equals SIQOperationsWaitingWarn, but is less than SIQOperationsWaitingCrit, the check result is WARNING. If the evaluated figure is more than or equals SIQOperationsWaitingCrit, the check result is CRITICAL.

The check retrieves a current amount of database server threads available for use. The more threads available, the better.

If the evaluated figure falls below or equals SIQThreadsWarn, but is still more than SIQThreadsCrit, the check result is WARNING. If the evaluated figure is less than or equals SIQThreadsCrit, the check result is CRITICAL.

The check verifies if enough free space is available in all dataspaces. If the usage or the amount of remaining free space is exceeding/falling below SIQDataSpacesUsageCrit the check status will be Critical. If the usage or the amount of remaining free space is exceeding/falling below SIQDataSpacesUsageWarn but is still below/above SIQDataSpacesUsageCrit, the status will be warning.

The total check status is the worst of all sub-status of all dataspaces. You can see the sub-result for each dataspace in the table provided. This checks features Monitoring Exception Parameters so you may define individual thresholds for certain dataspaces.

This check retrieves the information about the Automatic table maintenance in ASE database. If at least one window is not scheduled/active, then the check result is Warning. If all windows are scheduled and active, the result is OK.

The check verifies if the last dump for each database was successful. If the last dump has failed, the check result will be Warning.

Then the check looks for the last successful dump for each database. If there is none at all (at least none in SYBBackupSelectRange days) or if the time since the last dump is above threshold BackupAgeCrit, the check result will be Critical.

If there is a successful dump and the time since the last dump is below BackupAgeCrit but above BackupAgeWarn the check result will be Warning.

The total check status is the worst of all sub-status of all databases. You can see the sub-result for each database in the table provided. Please note that the size of backup dump files can only be displayed if the file still exists on the file system. You may exclude databases that are not backed up using parameter SYBBackupExclude. 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 the official SAP guide 'SAP Business Suite on SAP Adaptive Server Enterprise'.

The check complements the Daily Check SYB_Backup by a RealTime Monitoring check, which immediately displays a Warning or Critical status when the last backup has failed. The status displayed after a backup has failed can be configured with monitoring parameter SYBBackupStatFailedStatus. SYBBackupStatFailedDisplayTime minutes after the failed backup has been detected, the check result status is reset to Ok.

If a backup is currently being processed, the check verifies the current runtime since the backup start and compares it against the average backup time of the last 5 successful backups, and additionally, it is compared against a static time threshold. This shall help to reduce false alerts especially if average backup times are small. If the current runtime takes more than 50 percent longer than the average and is above SYBBackupStatDelayTimeWarn minutes the check status is set to Warning. If it takes more than 100 percent longer and is above SYBBackupStatDelayTimeCrit minutes the check status is set to Critical.

If no 5 successful backups are found the check takes the average runtime of as many backups as possible. If none is found at all, the average runtime is initialized to 2 hours.

Please note that this check does not check the age of the last successful backup. This is done by Daily Check SYB_Backup.

This check analyses the results of the SAP ASE configuration checks. Check results are presented as a table, each result is evaluated. If at least one row in the table is PARAM_RESULT = 1, then the status is WARNING. The check status is CRITICAL if at least one row has PARAM_RESULT = 2. If all configuration check rows have PARAM_RESULT = 0, then the check status is OK.

The check verifies the durability status of all databases found and checks if it is set to full. Temporary databases have durability status no_recovery and are automatically excluded. If a database with a durability status not equal to full or at_shutdown is found, the check result will be Warning.

More importantly, the check verifies if suspect pages are reported for a database. If yes, the check status will be Critical. If a database is marked as suspect, you should find the reason for this. Usually, there are entries in the error log. Please refer to Sybase/SAP documentation on how to proceed and how to reset the suspect status.

The check table includes much information for your reference and overview. The same data is checked elsewhere, e.g. in checks SYB_DataSpaces and SYB_LogSpaces.

The check verifies if enough data space is available in all databases. If the usage or the amount of remaining free space is exceeding/falling below SYBDBUsageCrit the check status will be Critical. If the usage or the amount of remaining free space is exceeding/falling below SYBDBUsageWarn but is still below/above SYBDBUsageCrit, the status will be warning.

The total check status is the worst of all sub-status of all databases. You can see the sub-result for each database in the table provided. This checks features Monitoring Exception Parameters so you may define individual thresholds for certain databases.

The check queries the Sybase error log for entries within the last day. If Monitoring Parameter RunDailyCheckOnWE is false, the check queries the error log for the last 2 days on Sundays, and for the last 3 days on Mondays, to make sure you do not miss any entries.

The check status is Ok if no entries at all or only entries with severity level 0 or 10 are found. If any entries with severity level >=11 and ⇐16 are found, the check status is Warning. If entries with severity level 17 or above are found, the check result will be critical.

Severity level 17 means Insufficient Resources, for example, space allocation fails due to missing free extents in a data segment.

Severity level 21 and above means, that SAP ASE needs to be restarted or is damaged and must be repaired.

Please check the SAP Sybase ASE guide System Administration Guide: Volume 1 for information on severity levels and how to proceed in case you encounter severe error log entries.

Monitoring Parameter SYBErrorLogExcludeErrNums may be used to exclude certain error numbers from being checked.

Enter a comma or blank-separated list of numbers to specify multiple values.

SYB_ErrorLogStat does the same as SYB_ErrorLog — monitoring the ASE error log, but queries it for entries within last SYBErrorLogTimeSpan minutes only and reports to RealTime Monitoring.

SYB_LogBackup monitors, if the last transaction log backup is recent enough. This is important to ensure the recoverability of your databases.

If the last transaction log dump is above SYBLogBackupAgeWarn minutes ago, but below SYBLogBackupAgeCrit minutes, the check status is Warning. If the last transaction log dump is above SYBLogBackupAgeCrit minutes ago, the check result is Critical. If a database reports a full transaction log, the check result is reported Critical. Please note that a full transaction log should usually not happen, since exhausting log space should be reported in advance by the SYB_LogSpaces check.

You may exclude databases from being checked by adding the name of the database to the comma-separated list defined by Monitoring Parameter SYBLogBackupExclude. Many system databases are already excluded by default. However, databases are still checked for the full transaction log, no matter if excluded or not.

This check corresponds to the SYB_DataSpaces check but verifies if enough log space is available in all databases. If the usage or the amount of remaining free space is exceeding/falling below SYBLogUsageCrit, the check status will be Critical. If the usage or the amount of remaining free space is exceeding/falling below SYBLogUsageWarn but is still below/above SYBLogUsageCrit, the status will be warning.

The total check status is the worst of all sub-status of all databases. You can see the sub-result for each database in the table provided. In contrast to SYB_DataSpaces, this Check does not feature Monitoring Exception Parameters.