## 6.1 Alerts Reference
Details of alerts in HANA 2.0 SPS07.
| ID:                    | 0                                                                                                                                                                  |
|------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Internal statistics server problem                                                                                                                                 |
| Description:           | Identifies internal statistics server problem.                                                                                                                     |
| Category:              | Availability                                                                                                                                                       |
| User Action:           | Resolve the problem. For more information, see the trace files. You may need to activate tracing first.                                                            |
| Further information:   | SAP Note: 1803039 Statistics server CHECK_HOSTS_CPU intern. error when restart                                                                                     |
| ID:                    | 1                                                                                                                                                                  |
| Name:                  | Host physical memory usage                                                                                                                                         |
| Description:           | Determines what percentage of total physical memory available on the host is used. All processes consuming memory are considered, including non-SAP HANAprocesses. |
| Description:           |  Note Only relevant in HANA1.0. Not active in HANA2.0. See SAP Note: 2757696 Alert 1 shows wrong information                                                      |
| Category:              | Memory                                                                                                                                                             |
| Unit:                  | percent                                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 95; 98; 100 Severity level(s): 2; 3; 4                                                                                                       |
| User Action:           | Investigate memory usage of processes.                                                                                                              |
|------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------|
| Further information:   | SAP Note: 1898317 How to handle HANAAlert 1: 'Host physical memory usage'; SAP Note: 1840954 Alerts related to HANAmemoryconsumption                |
| ID:                    | 2                                                                                                                                                   |
| Name:                  | Disk usage                                                                                                                                          |
| Description:           | Determines what percentage of each disk containing data, log, and trace files is used. This includes space used by non-SAP HANAfiles.               |
| Category:              | Disk                                                                                                                                                |
| Unit:                  | percent                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 90; 95; 98 Severity level(s): 2; 3; 4                                                                                         |
| User Action:           | Investigate disk usage of processes. Increase disk space, for example by shrinking volumes, deleting diagnosis files, or adding additional storage. |
| Further information:   | SAP Note: 1900643 How to handle HANAAlert 2: 'Disk usage'                                                                                           |
| ID:                    | 3                                                                                                                                                   |
| Name:                  | Inactive services                                                                                                                                   |
| Description:           | Identifies inactive services.                                                                                                                       |
| Category:              | Availability                                                                                                                                        |
| Unit:                  | seconds                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 600 Severity level(s): 4                                                                                                      |
| User Action:           | Investigate why the service is inactive, for example, by checking the service's trace files.                                                        |
| Further information:   | Inactive > 600 seconds. SAP Note: 1902033 How to handle HANAAlert 3: 'Inactive Services'                                                            |
| ID:                    | 4                                                                                                                                                   |
| Name:                  | Restarted services                                                                                                                                  |
| Description:           | Identifies services that have restarted since the last time the check was performed.                                                                |
| Category:              | Availability                                                                                                    |
|------------------------|-----------------------------------------------------------------------------------------------------------------|
| User Action:           | Investigate why the service had to restart or be restarted, for example, by checking the service's trace files. |
| Further information:   | SAP Note: 1909660 How to handle HANAAlert 4: 'Restarted services'                                               |
| ID:                    | 5                                                                                                               |
| Name:                  | Host CPU Usage                                                                                                  |
| Description:           | Determines the percentage CPU idle time on the host and therefore whether or not CPU resources are running low. |
| Category:              | CPU                                                                                                             |
| Unit:                  | percent                                                                                                         |
| Thresholds / Severity: | Default threshold(s): 25; 15; 10 Severity level(s): 2; 3; 4                                                     |
| User Action:           | Investigate CPU usage.                                                                                          |
| Further information:   | SAP Note: 1909670 How to handle HANAAlert 5: 'Host CPU Usage'                                                   |
| ID:                    | 6                                                                                                               |
| Name:                  | Address space usage                                                                                             |
| Description:           | Determines the address space consumption                                                                        |
| Category:              | Memory                                                                                                          |
| Unit:                  | percent                                                                                                         |
| Thresholds / Severity: | Default threshold(s): 70; 80; 90 Severity level(s): 2; 3; 4                                                     |
| User Action:           | Prepare to restart HANA.                                                                                        |
| ID:                    | 7                                                                                                               |
| Name:                  | Timer fallback                                                                                                  |
| Description:           | Notifies about the usage of the system timer fallback. The system timer is slower than native HANAtimer.        |
| Category:              | Configuration                                                                                                   |
| User Action:           | Use HANAonasystem configuration with Time Stamp Counter invariant set. See SAP Note 2753418.                                                                                                                                                                                    |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Further information:   | SAP Note: 2753418 Potential Performance Degradation Due to Timer Fallback                                                                                                                                                                                                       |
| ID:                    | 10                                                                                                                                                                                                                                                                              |
| Name:                  | Delta merge (mergedog) configuration                                                                                                                                                                                                                                            |
| Description:           | Determines whether or not the 'active' parameter in the 'mergedog' section of system con- figuration file(s) is 'yes'. mergedog is the system process that periodically checks column tables to determine whether or not a delta merge operation needs to be executed.          |
| Category:              | Configuration                                                                                                                                                                                                                                                                   |
| User Action:           | Change in SYSTEM layer the parameter active in section(s) mergedog to yes                                                                                                                                                                                                       |
| Further information:   | SAP Note: 1909641 How to handle HANAAlert 10 - 'Delta Merge (mergedog) Configura- tion'                                                                                                                                                                                         |
| ID:                    | 12                                                                                                                                                                                                                                                                              |
| Name:                  | Memory usage of name server                                                                                                                                                                                                                                                     |
| Description:           | Determines what percentage of allocated shared memory is being used by the name server on a host.                                                                                                                                                                               |
| Category:              | Memory                                                                                                                                                                                                                                                                          |
| Unit:                  | percent                                                                                                                                                                                                                                                                         |
| Thresholds / Severity: | Default threshold(s): 70; 80 Severity level(s): 3; 4                                                                                                                                                                                                                            |
| User Action:           | Increase the shared memory size of the name server. In the 'topology' section of the name- server.ini file, increase the value of the 'size' parameter.                                                                                                                         |
| Further information:   | SAP Note: 1977101 How to handle HANAAlert 12: 'Memory usage of name server'                                                                                                                                                                                                     |
| ID:                    | 17                                                                                                                                                                                                                                                                              |
| Name:                  | Record count of non-partitioned column-store tables                                                                                                                                                                                                                             |
| Description:           | Determines the number of records in non-partitioned column-store tables. Current table size may not be critical. Partitioning need only be considered if tables are expected to grow rapidly (a non-partitioned table cannot contain more than 2,147,483,648 (2 billion) rows). |
| Category:              | Memory                                                                                                                                                                                                                                                                          |
| Unit:                  | records                                                                                                                                                                                                                                                                                                                                                               |
|------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Thresholds / Severity: | Default threshold(s): 300000000 Severity level(s): 1                                                                                                                                                                                                                                                                                                                  |
| User Action:           | Consider partitioning the table only if you expect it to grow rapidly.                                                                                                                                                                                                                                                                                                |
| Further information:   | SAP HANAAdministration Guide > Table Partitioning, SAP Note: 1909763 How to handle HANAAlert 17: 'Record count of non-partitioned column-store tables'                                                                                                                                                                                                                |
| ID:                    | 20                                                                                                                                                                                                                                                                                                                                                                    |
| Name:                  | Table growth of non-partitioned column-store tables                                                                                                                                                                                                                                                                                                                   |
| Description:           | Determines the growth rate of non-partitioned columns tables.                                                                                                                                                                                                                                                                                                         |
| Category:              | Memory                                                                                                                                                                                                                                                                                                                                                                |
| Unit:                  | percent                                                                                                                                                                                                                                                                                                                                                               |
| Thresholds / Severity: | Default threshold(s): 5; 7,5; 10 Severity level(s): 2; 3; 4                                                                                                                                                                                                                                                                                                           |
| User Action:           | Consider partitioning the table. See also: Guided Answer: How to reduce the size of a table.                                                                                                                                                                                                                                                                          |
| Further information:   | SAP HANAAdministration Guide > Table Partitioning, SAP Note: 1910140 How to Handle Alert 20 'Table growth of non-partitioned column-store tables'                                                                                                                                                                                                                     |
| ID:                    | 21                                                                                                                                                                                                                                                                                                                                                                    |
| Name:                  | Internal event (Information event)                                                                                                                                                                                                                                                                                                                                    |
| Description:           | Identifies internal database events. Some events, which do not generate a specific alert, are captured as internal (or 'info') events. Info events trigger alert 21 and details of the event, together with an event ID value, are logged in the view M_EVENTS. Refer to the 'Additional info' value of the event for more information about the source of the event. |
| Category:              | Availability                                                                                                                                                                                                                                                                                                                                                          |
| Severity:              | INFO                                                                                                                                                                                                                                                                                                                                                                  |
| User Action:           | No action required.                                                                                                                                                                                                                                                                                                                                                   |
| Further information:   | SAP Note: 3435373 Alert 21 Flooding 'Too many jobs collecting disk info' and 'Disk info job stuck for very long time'                                                                                                                                                                                                                                                 |
| ID:                    | 22                                                                                                                                                                                                        |
|------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Notification of all alerts                                                                                                                                                                                |
| Description:           | Determines whether or not there have been any alerts since the last check and if so, sends a summary e-mail to specified recipients.                                                                      |
| Category:              | Availability                                                                                                                                                                                              |
| User Action:           | Investigate the alerts.                                                                                                                                                                                   |
| ID:                    | 23                                                                                                                                                                                                        |
| Name:                  | Notification of medium and high priority alerts                                                                                                                                                           |
| Description:           | Determines whether or not there have been any medium and high priority alerts since the last check and if so, sends a summary e-mail to specified recipients.                                             |
| Category:              | Availability                                                                                                                                                                                              |
| User Action:           | Investigate the alerts.                                                                                                                                                                                   |
| ID:                    | 24                                                                                                                                                                                                        |
| Name:                  | Notification of high priority alerts                                                                                                                                                                      |
| Description:           | Determines whether or not there have been any high priority alerts since the last check and if so, sends a summary e-mail to specified recipients.                                                        |
| Category:              | Availability                                                                                                                                                                                              |
| User Action:           | Investigate the alerts.                                                                                                                                                                                   |
| ID:                    | 25                                                                                                                                                                                                        |
| Name:                  | Open connections                                                                                                                                                                                          |
| Description:           | Determines what percentage of the maximum number of permitted SQL connections are open. The maximum number of permitted connections is configured in the "session" sec- tion of the indexserver.ini file. |
| Category:              | Sessions/Transactions                                                                                                                                                                                     |
| Unit:                  | percent                                                                                                                                                                                                   |
| Thresholds / Severity: | Default threshold(s): 90; 95; 98 Severity level(s): 2; 3; 4                                                                                                                                               |
| User Action:           | Investigate why the maximum number of permitted open connections is being approached.                                                                                                                     |
| Further information:   | SAP Note: 1910159 How to handle HANAAlert 25: 'Check number of connections'                                                                                                                 |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| ID:                    | 26                                                                                                                                                                                          |
| Name:                  | Unassigned volumes                                                                                                                                                                          |
| Description:           | Identifies volumes that are not assigned a service.                                                                                                                                         |
| Category:              | Configuration                                                                                                                                                                               |
| User Action:           | Investigate why the volume is not assigned a service. For example, the assigned service is not active, the removal of a host failed, or the removal of a service was performed incorrectly. |
| Further information:   | SAP Note: 1910169 How to handle HANAAlert 26: 'Unassigned volumes'                                                                                                                          |
| ID:                    | 27                                                                                                                                                                                          |
| Name:                  | Record count of column-store table partitions                                                                                                                                               |
| Description:           | Determines the number of records in the partitions of column-store tables. A table partition cannot contain more than 2,147,483,648 (2 billion) rows.                                       |
| Category:              | Memory                                                                                                                                                                                      |
| Unit:                  | records                                                                                                                                                                                     |
| Thresholds / Severity: | Default threshold(s): 1500000000; 1800000000; 1900000000                                                                                                                                    |
| User Action:           | Consider repartitioning the table.                                                                                                                                                          |
| Further information:   | SAP HANAAdministration Guide > Table Partitioning, SAP Note: 1910188 How to handle HANAAlert 27: 'Record count of column-store table partitions'                                            |
| ID:                    | 28                                                                                                                                                                                          |
| Name:                  | Most recent savepoint operation                                                                                                                                                             |
| Description:           | Determines how long ago the last savepoint was defined, that is, how long ago a complete, consistent image of the database was persisted to disk.                                           |
| Category:              | Disk                                                                                                                                                                                        |
| Unit:                  | minutes                                                                                                                                                                                     |
| Thresholds / Severity: | Default threshold(s): 60; 120; 300 Severity level(s): 1; 2; 3                                                                                                                               |
| User Action:           | Investigate why there was a delay defining the last savepoint and consider triggering the operation manually by executing the SQL statement ALTER SYSTEM SAVEPOINT.                                                                                                                                                    |
|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Further information:   | SAP Note: 1977291 Handle HANAAlert 28: 'Most recent savepoint operation'                                                                                                                                                                                                                                               |
| ID:                    | 29                                                                                                                                                                                                                                                                                                                     |
| Name:                  | Size of delta storage of column-store tables                                                                                                                                                                                                                                                                           |
| Description:           | Determines exceptionally large delta storages of column tables.                                                                                                                                                                                                                                                        |
| Category:              | Memory                                                                                                                                                                                                                                                                                                                 |
| Unit:                  | values <= 100 in percent of the process allocation limit on the host where the table is located, greater values inMB                                                                                                                                                                                                   |
| Thresholds / Severity: | Default %threshold(s): 0.5; 1.0; 2.0; 4.0 Severity level(s): 1; 2; 3; 4                                                                                                                                                                                                                                                |
| User Action:           | See SAP Knowledge Base Note 1977314. Investigate the delta merge history in the monitor- ing view M_DELTA_MERGE_STATISTICS. Consider merging the table delta manually.                                                                                                                                                 |
| Further information:   | SAP Note: 1977314 How to handle HANAAlert 29: 'Size of delta storage of column-store tables'                                                                                                                                                                                                                           |
| ID:                    | 30                                                                                                                                                                                                                                                                                                                     |
| Name:                  | Check internal disk full event                                                                                                                                                                                                                                                                                         |
| Description:           | Determines whether or not the disks to which data and log files are written are full. A disk-full event causes your database to stop and must be resolved.                                                                                                                                                             |
| Category:              | Disk                                                                                                                                                                                                                                                                                                                   |
| Unit:                  | state                                                                                                                                                                                                                                                                                                                  |
| Thresholds / Severity: | Default threshold(s): HANDLED,NEW Severity level(s): 2; 4                                                                                                                                                                                                                                                              |
| User Action:           | Resolve the disk-full event as follows: In the Administration Editor on the Overview tab, choose the "Disk Full Events" link and mark the event as handled. Alternatively, execute the SQL statements ALTER SYSTEM SET EVENT ACKNOWLEDGED'<host>:<port>' <id> and ALTER SYSTEM SET EVENT HANDLED '<host>:<port>' <id>. |
| Further information:   | SAP Note: 1898460 How to Handle Alert 30 'Internal disk-full event'                                                                                                                                                                                                                                                    |
| ID:                    | 31                                                                                                                                                                                                                                                                                                                     |
| Name:                  | License expiry                                                                                                                                                                                                                                                                                                                 |
|------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Description:           | Determines how many days until your license expires. Once your license expires, you can no longer use the system, except to install a new license.                                                                                                                                                                             |
| Category:              | Availability                                                                                                                                                                                                                                                                                                                   |
| Unit:                  | day                                                                                                                                                                                                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 30; 14; 7 Severity level(s): 2; 3; 4                                                                                                                                                                                                                                                                     |
| User Action:           | Obtain a valid license and install it. For the exact expiration date, see the monitoring view M_LICENSE.                                                                                                                                                                                                                       |
| Further information:   | Security, Authorization and Licensing, SAP Note: 1899480 How to handle HANAAlert 31: 'License expiry'                                                                                                                                                                                                                          |
| ID:                    | 33                                                                                                                                                                                                                                                                                                                             |
| Name:                  | Log mode OVERWRITE                                                                                                                                                                                                                                                                                                             |
| Description:           | Determines whether or not the database is running in log mode "overwrite". Log mode "overwrite" does not support point-in-time-recovery (only recovery to a data backup) and is not recommended for productive systems.                                                                                                        |
| Category:              | Backup                                                                                                                                                                                                                                                                                                                         |
| User Action:           | If you need point-in-time recovery, reconfigure the log mode of your system to "normal". In the "persistence" section of the global.ini configuration file, set the parameter "log_mode" to "normal" for the System layer. You are recommended to perform a full data backup. See Issues with Configuration Parameter log_mode |
| Further information:   | SAP HANAAdministration Guide > Backup and Recovery, SAP Note: 1900267 How to handle HANAAlert 33 - 'Log mode OVERWRITE'                                                                                                                                                                                                        |
| ID:                    | 34                                                                                                                                                                                                                                                                                                                             |
| Name:                  | Unavailable volumes                                                                                                                                                                                                                                                                                                            |
| Description:           | Determines whether or not all volumes are available.                                                                                                                                                                                                                                                                           |
| Category:              | Configuration                                                                                                                                                                                                                                                                                                                  |
| User Action:           | Investigate why the volume is not available.                                                                                                                                                                                                                                                                                   |
| Further information:   | SAP HANAAdministration Guide > Backup and Recovery, SAP Note: 1900682 How to handle HANAAlert 34: Unavailable Volumes                                                                                                                                                                                                          |
| ID:                    | 35                                                                                                                                    |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Existence of data backup                                                                                                              |
| Description:           | Determines whether or not a data backup exists. Without a data backup, your database cannot be recovered.                             |
| Category:              | Backup                                                                                                                                |
| User Action:           | Perform a data backup as soon as possible.                                                                                            |
| Further information:   | SAP HANAAdministration Guide > Backup and Recovery, SAP Note: 1900728 How to handle HANAAlert 35: 'Existence of Data Backup'          |
| ID:                    | 36                                                                                                                                    |
| Name:                  | Status of most recent data backup                                                                                                     |
| Description:           | Determines whether or not the most recent data backup was successful.                                                                 |
| Category:              | Backup                                                                                                                                |
| User Action:           | Investigate why the last data backup failed, resolve the problem, and perform a new data backup as soon as possible.                  |
| Further information:   | SAP HANAAdministration Guide > Backup and Recovery, SAP Note: 1900795 How to handle HANAalert 36: 'Status of Most Recent Data Backup' |
| ID:                    | 37                                                                                                                                    |
| Name:                  | Age of most recent data backup                                                                                                        |
| Description:           | Determines the age of the most recent successful data backup.                                                                         |
| Category:              | Backup                                                                                                                                |
| Unit:                  | day                                                                                                                                   |
| Thresholds / Severity: | Default threshold(s): 5; 7 ; 20 Severity level(s): 2; 3; 4                                                                            |
| User Action:           | Perform a data backup as soon as possible.                                                                                            |
| Further information:   | SAP HANAAdministration Guide > Backup and Recovery, SAP Note: 1900730 How to handle HANAAlert 37 - 'Age of most recent data backup'   |
| ID:                    | 38                                                                                                                                    |
| Name:                  | Status of most recent log backups                                                                                                     |
| Description:           | Determines whether or not the most recent log backups for services and volumes were successful.                                                                                                                |
|------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Category:              | Backup                                                                                                                                                                                                         |
| User Action:           | Investigate why the log backup failed and resolve the problem.                                                                                                                                                 |
| Further information:   | SAP HANAAdministration Guide > Backup and Recovery, SAP Note: 1900788 How to handle HANAAlert 38: 'Status of Most Recent Log Backup'                                                                           |
| ID:                    | 39                                                                                                                                                                                                             |
| Name:                  | Long-running statements                                                                                                                                                                                        |
| Description:           | Identifies long-running SQL statements.                                                                                                                                                                        |
| Category:              | Sessions/Transactions                                                                                                                                                                                          |
| Unit:                  | seconds                                                                                                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 1800; 2700; 3600 Severity level(s): 1; 2; 3                                                                                                                                              |
| User Action:           | Investigate the statement. For more information, see the table _SYS_STATIS- TICS.HOST_LONG_RUNNING_STATEMENTS.                                                                                                 |
| Further information:   | SAP Note: 1849392 HANAalerts related to locks, hanging sessions and long runners                                                                                                                               |
| ID:                    | 40                                                                                                                                                                                                             |
| Name:                  | Total memory usage of column-store tables                                                                                                                                                                      |
| Description:           | Determines what percentage of the effective allocation limit is being consumed by individual column-store tables as a whole (that is, the cumulative size of all of a table's columns and internal structures) |
| Category:              | Memory                                                                                                                                                                                                         |
| Unit:                  | percent                                                                                                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 20; 25; 30                                                                                                                                                                               |
| User Action:           | Consider partitioning or repartitioning the table.                                                                                                                                                             |
| Further information:   | SAP Note: 1977268 How to handle HANAAlert 40: 'Total memory usage of column-store tables'                                                                                                                      |
| ID:                    | 41                                                                                                                                                                                                                                |
|------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | In-memory DataStore activation                                                                                                                                                                                                    |
| Description:           | Determines whether or not there is a problem with the activation of an in-memory Data- Store object.                                                                                                                              |
| Category:              | Availability                                                                                                                                                                                                                      |
| User Action:           | For more information, see the table _SYS_STATISTICS.GLOBAL_DEC_EXTRACTOR_STATUS and SAP Note 1665553.                                                                                                                             |
| Further information:   | SAP Note: 1665553 How to handle HANAAlert 41: 'Check the In-memory DataStore activation'; SAP Note: 1977230 Handling issues with IMDSO activation-SAPHANADXC                                                                      |
| ID:                    | 42                                                                                                                                                                                                                                |
| Name:                  | Long running/idling cursors                                                                                                                                                                                                       |
| Description:           | Identifies long running/idling cursors. The threshold is based on M_INIFILE_CON- TENTS.VALUE where KEY = "idle_cursor_lifetime".                                                                                                  |
| Category:              | Sessions/Transactions                                                                                                                                                                                                             |
| Unit:                  | ratio                                                                                                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 0.5; 0.7 ;0.9 Severity level(s): 2; 3; 4                                                                                                                                                                    |
| User Action:           | Close the cursor in the application, or kill the connection by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION <LOGICAL_CONNECTION_ID>.For more informa- tion, see the table HOST_LONG_IDLE_CURSOR (_SYS_STATISTICS). |
| Further information:   | SAP Note: 1900261 How to handle HANAAlert 42: 'Long-Running Cursors'                                                                                                                                                              |
| ID:                    | 43                                                                                                                                                                                                                                |
| Name:                  | Memory usage of services                                                                                                                                                                                                          |
| Description:           | Determines what percentage of its effective allocation limit a service is using.                                                                                                                                                  |
| Category:              | Memory                                                                                                                                                                                                                            |
| Unit:                  | percent                                                                                                                                                                                                                           |
| Thresholds / Severity: | Default threshold(s): 80; 90; 95 Severity level(s): 2; 3; 4                                                                                                                                                                       |
| User Action:           | Check for services that consume a lot of memory.                                                                                                                                                                                  |
| Further information:   | SAP Note: 1900257 How to handle HANAAlert 43: 'Memory Usage of Services'                                                                                                                                      |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| ID:                    | 44                                                                                                                                                                                                            |
| Name:                  | Licensed memory usage                                                                                                                                                                                         |
| Description:           | Determines what percentage of licensed memory is used.                                                                                                                                                        |
| Category:              | Memory                                                                                                                                                                                                        |
| Unit:                  | percent                                                                                                                                                                                                       |
| Thresholds / Severity: | Default threshold(s): 98 Severity level(s): 1                                                                                                                                                                 |
| User Action:           | Increase licensed amount of main memory. You can see the peak memory allocation since installation in the system view M_LICENSE (column PRODUCT_USAGE).                                                       |
| Further information:   | SAP Note: 1899511 How to handle HANAAlert 44 'Licensed Memory Usage'                                                                                                                                          |
| ID:                    | 45                                                                                                                                                                                                            |
| Name:                  | Memory usage of main storage of column-store tables                                                                                                                                                           |
| Description:           | Determines what percentage of the effective allocation limit is being consumed by the main storage of individual column-store tables.                                                                         |
| Category:              | Memory                                                                                                                                                                                                        |
| Unit:                  | percent                                                                                                                                                                                                       |
| Thresholds / Severity: | Default threshold(s): 20; 25; 30 Severity level(s): 1; 2; 3                                                                                                                                                   |
| User Action:           | Consider partitioning or repartitioning the table.                                                                                                                                                            |
| Further information:   | SAP Note: 1977269 How to handle HANAAlert 45: 'Check memory usage of main stor- age of column-store tables'                                                                                                   |
| ID:                    | 46                                                                                                                                                                                                            |
| Name:                  | RTEdump files                                                                                                                                                                                                 |
| Description:           | Identifies new runtime dump files (*rtedump*) have been generated in the trace directory of the system. These contain information about, for example, build, loaded modules, running threads, CPU, and so on. |
| Category:              | Diagnosis Files                                                                                                                                                                                               |
| User Action:           | Check the contents of the dump files.                                                                                                                                                                                                                               |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Further information:   | SAP Note: 1977099 How to handle HANAAlert 46: 'Check for new RTE dump files'                                                                                                                                                                                        |
| ID:                    | 47                                                                                                                                                                                                                                                                  |
| Name:                  | Long-running serializable transactions                                                                                                                                                                                                                              |
| Description:           | Identifies long-running serializable transactions.                                                                                                                                                                                                                  |
| Category:              | Sessions/Transactions                                                                                                                                                                                                                                               |
| Unit:                  | ratio                                                                                                                                                                                                                                                               |
| Thresholds / Severity: | Default threshold(s): 0.7; 0.9 Severity level(s): 3; 4                                                                                                                                                                                                              |
| User Action:           | Close the serializable transaction in the application or kill the connection by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION <LOGICAL_CONNECTION_ID>. For more information, see the table HOST_LONG_SERIALIZABLE_TRANSACTION (_SYS_STA- TISTICS).    |
| Further information:   | Transactional Problems [page 167]                                                                                                                                                                                                                                   |
| ID:                    | 48                                                                                                                                                                                                                                                                  |
| Name:                  | Long-running uncommitted write transactions                                                                                                                                                                                                                         |
| Description:           | Identifies long-running uncommitted write transactions.                                                                                                                                                                                                             |
| Category:              | Sessions/Transactions                                                                                                                                                                                                                                               |
| Unit:                  | ratio                                                                                                                                                                                                                                                               |
| Thresholds / Severity: | Default threshold(s): 0.7; 0.9 Severity level(s): 3; 4                                                                                                                                                                                                              |
| User Action:           | Close the uncommitted transaction in the application or kill the connection by exe- cuting the SQL statement ALTER SYSTEM DISCONNECT SESSION <LOGICAL_CONNEC- TION_ID>. For more information, see the table HOST_UNCOMMITTED_WRITE_TRANSAC- TION (_SYS_STATISTICS). |
| Further information:   | SAP Note: 1977276 How to handle HANAAlert 48: 'Check a long-running uncommitted write transaction'                                                                                                                                                                  |
| ID:                    | 49                                                                                                                                                                                                                                                                  |
| Name:                  | Long-running blocking situations                                                                                                                                                                                                                                    |
| Description:           | Identifies long-running blocking situations.                                                                                                                                                                                                   |
|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Category:              | Sessions/Transactions                                                                                                                                                                                                                          |
| Unit:                  | minutes                                                                                                                                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 15; 20; 25 Severity level(s): 2; 3; 4                                                                                                                                                                                    |
| User Action:           | Investigate the blocking and blocked transactions and if appropriate cancel one of them.                                                                                                                                                       |
| Further information:   | SAP Note: 2079396 How to handle HANAAlert 49: 'long-running blocking transaction'                                                                                                                                                              |
| ID:                    | 50                                                                                                                                                                                                                                             |
| Name:                  | Number of diagnosis files                                                                                                                                                                                                                      |
| Description:           | Determines the number of diagnosis files written by the system (excluding zip-files). An unusually large number of files can indicate a problem with the database (for example, problem with trace file rotation or a high number of crashes). |
| Category:              | Diagnosis Files                                                                                                                                                                                                                                |
| Unit:                  | files                                                                                                                                                                                                                                          |
| Thresholds / Severity: | Default threshold(s): 200 Severity level(s): 2                                                                                                                                                                                                 |
| User Action:           | Investigate the diagnosis files.                                                                                                                                                                                                               |
| Further information:   | SAP Note: 1977162 How to handle HANAAlert 50: 'Number of Diagnosis files'                                                                                                                                                                      |
| ID:                    | 51                                                                                                                                                                                                                                             |
| Name:                  | Size of diagnosis files                                                                                                                                                                                                                        |
| Description:           | Identifies large diagnosis files. Unusually large files can indicate a problem with the data- base.                                                                                                                                            |
| Category:              | Diagnosis Files                                                                                                                                                                                                                                |
| Unit:                  | MB                                                                                                                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 1024; 2048 Severity level(s): 2; 3                                                                                                                                                                                       |
| User Action:           | Check the diagnosis files in the SAP HANAstudio for details.                                                                                                                                                                                   |
| Further information:   | SAP Note: 1977208 How to handle HANAAlert 51: 'Size of diagnosis files'                                                                                                                                                                        |
| ID:                    | 52                                                                                                                                                        |
|------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Crashdump files                                                                                                                                           |
| Description:           | Identifies new crashdump files that have been generated in the trace directory of the sys- tem.                                                           |
| Category:              | Diagnosis Files                                                                                                                                           |
| User Action:           | Check the contents of the dump files.                                                                                                                     |
| Further information:   | SAP Note: 1977218 How to handle HANAAlert 52 'Check for new crash dump files'                                                                             |
| ID:                    | 53                                                                                                                                                        |
| Name:                  | Pagedump files                                                                                                                                            |
| Description:           | Identifies new pagedump files that have been generated in the trace directory of the system.                                                              |
| Category:              | Diagnosis Files                                                                                                                                           |
| User Action:           | Check the contents of the dump files.                                                                                                                     |
| Further information:   | SAP Note: 1977242 How to handle HANAAlert 53: 'Pagedump files'                                                                                            |
| ID:                    | 54                                                                                                                                                        |
| Name:                  | Savepoint duration                                                                                                                                        |
| Description:           | Identifies long-running savepoint operations.                                                                                                             |
| Category:              | Backup                                                                                                                                                    |
| Unit:                  | seconds                                                                                                                                                   |
| Thresholds / Severity: | Default threshold(s): 300; 600; 900 Severity level(s): 1; 2; 3                                                                                            |
| User Action:           | Check disk I/O performance.                                                                                                                               |
| Further information:   | CPU Related Root Causes and Solutions, I/O Related Root Causes and Solutions [page 114], SAP Note: 1977220 How to handle HANAAlert 54: Savepoint Duration |
| ID:                    | 55                                                                                                                                                        |
| Name:                  | Columnstore unloads                                                                                                                                       |
| Description:           | Determines how many columns in columnstore tables have been unloaded from memory. This can indicate performance issues.                                   |
| Category:              | Memory                                                                                                                  |
|------------------------|-------------------------------------------------------------------------------------------------------------------------|
| Unit:                  | tables                                                                                                                  |
| Thresholds / Severity: | Default threshold(s): 1000; 10000; 100000 Severity level(s): 1; 2; 3                                                    |
| User Action:           | Check sizing with respect to data distribution.                                                                         |
| Further information:   | SAP Note: 1977207 How to handle HANAAlert 55: Columnstore unloads                                                       |
| ID:                    | 56                                                                                                                      |
| Name:                  | Python trace activity                                                                                                   |
| Description:           | Determines whether or not the python trace is active and for how long. The python trace affects system performance.     |
| Category:              | Diagnosis Files                                                                                                         |
| Unit:                  | minutes                                                                                                                 |
| Thresholds / Severity: | Default threshold(s): 20; 60; 300 Severity level(s): 1; 2; 3                                                            |
| User Action:           | If no longer required, deactivate the python trace in the relevant configuration file.                                  |
| Further information:   | SAP Note: 1977098 How to handle HANAAlert 56: Python trace activity                                                     |
| ID:                    | 57                                                                                                                      |
| Name:                  | Instance secure store file system (SSFS) inaccessible                                                                   |
| Description:           | Determines if the instance secure store in the file system (SSFS) of your SAP HANAsystem is accessible to the database. |
| Category:              | Security                                                                                                                |
| Unit:                  | state                                                                                                                   |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 4                                                                            |
| User Action:           | Check and make sure that the instance SSFS is accessible to the database.                                               |
| Further information:   | SAP Note: 1977221 How to handle HANAAlert 57: 'Secure store file system (SSFS) availability'                            |
| ID:                    | 58                                                                                                                                                                                                                           |
|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Plan cache size                                                                                                                                                                                                              |
| Description:           | Determines whether or not the plan cache is too small.                                                                                                                                                                       |
| Category:              | Memory                                                                                                                                                                                                                       |
| Unit:                  | evictions                                                                                                                                                                                                                    |
| Thresholds / Severity: | Default threshold(s): 1000 Severity level(s): 1                                                                                                                                                                              |
| User Action:           | Currently Alert 58 is inactive and replaced by Alert 91. Please activate Alert 91 - Plan Cache Hit Ratio                                                                                                                     |
| Further information:   | SAP Note: 1977253 How to handle HANAAlert 58 - 'Plan Cache Size'                                                                                                                                                             |
| ID:                    | 59                                                                                                                                                                                                                           |
| Name:                  | Percentage of transactions blocked                                                                                                                                                                                           |
| Description:           | Determines the percentage of transactions that are blocked.                                                                                                                                                                  |
| Category:              | Sessions/Transactions                                                                                                                                                                                                        |
| Unit:                  | percent                                                                                                                                                                                                                      |
| Thresholds / Severity: | Default threshold(s): 5; 10; 20                                                                                                                                                                                              |
| User Action:           | Investigate blocking and blocked transactions and if appropriate cancel some of them.                                                                                                                                        |
| Further information:   | SAP Note: 2081856 How to handle HANAAlert 59: 'Percentage of transactions blocked'                                                                                                                                           |
| ID:                    | 60                                                                                                                                                                                                                           |
| Name:                  | Sync/Async read ratio                                                                                                                                                                                                        |
| Description:           | Identifies a bad trigger asynchronous read ratio. This means that asynchronous reads are blocking and behave almost like synchronous reads. This might have negative impact on SAP HANAI/O performance in certain scenarios. |
| Category:              | Disk                                                                                                                                                                                                                         |
| Unit:                  | ratio                                                                                                                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 0.5 Severity level(s): 1                                                                                                                                                                               |
| User Action:           | Please refer to SAP note 1930979.                                                                                                                                                                                                                                                                                                                                                                                          |
|------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Further information:   | I/O Related Root Causes and Solutions [page 114], SAP Note: 1965379 Correction of thresholds for Alerts 60 &61 in HANARevision 70 (SPS7)                                                                                                                                                                                                                                                                                   |
| ID:                    | 61                                                                                                                                                                                                                                                                                                                                                                                                                         |
| Name:                  | Sync/Async write ratio                                                                                                                                                                                                                                                                                                                                                                                                     |
| Description:           | Identifies a bad trigger asynchronous write ratio. This means that asynchronous writes are blocking and behave almost like synchronous writes. This might have negative impact on SAP HANAI/O performance in certain scenarios.                                                                                                                                                                                            |
| Category:              | Disk                                                                                                                                                                                                                                                                                                                                                                                                                       |
| Unit:                  | ratio                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Thresholds / Severity: | Default threshold(s): 0.5                                                                                                                                                                                                                                                                                                                                                                                                  |
| User Action:           | Please refer to SAP note 1930979.                                                                                                                                                                                                                                                                                                                                                                                          |
| Further information:   | I/O Related Root Causes and Solutions [page 114], SAP Note: 1965379 Correction of thresholds for Alerts 60 &61 in HANARevision 70 (SPS7)                                                                                                                                                                                                                                                                                   |
| ID:                    | 62                                                                                                                                                                                                                                                                                                                                                                                                                         |
| Name:                  | Expiration of database user passwords                                                                                                                                                                                                                                                                                                                                                                                      |
| Description:           | Identifies database users whose password is due to expire in line with the configured pass- word policy. If the password expires, the user will be locked. If the user in question is a technical user, this may impact application availability. It is recommended that you disable the password lifetime check of technical users so that their password never expires (ALTER USER <username> DISABLE PASSWORDLIFETIME). |
| Category:              | Security                                                                                                                                                                                                                                                                                                                                                                                                                   |
| User Action:           | Change the password of the database user.                                                                                                                                                                                                                                                                                                                                                                                  |
| Further information:   | SAP Note: 2082406 How to handle HANAAlert 62: Expiration of database user pass- words                                                                                                                                                                                                                                                                                                                                      |
| ID:                    | 63                                                                                                                                                                                                                                                                                                                                                                                                                         |
| Name:                  | Granting of SAP_INTERNAL_HANA_SUPPORT role                                                                                                                                                                                                                                                                                                                                                                                 |
| Description:           | Determines if the internal support role (SAP_INTERNAL_HANA_SUPPORT) is currently granted to any database users.                                                                                                                                                                                                                                                                                                            |
| Category:              | Security                                                                                                                                                                                                                           |
|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Unit:                  | users                                                                                                                                                                                                                              |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 2                                                                                                                                                                                       |
| User Action:           | Check if the corresponding users still need the role. If not, revoke the role from them.                                                                                                                                           |
| Further information:   | SAP Note: 2081857 Handle HANAAlert 63: Granting of SAP_INTERNAL_HANA_SUP- PORT role                                                                                                                                                |
| ID:                    | 64                                                                                                                                                                                                                                 |
| Name:                  | Total memory usage of table-based audit log                                                                                                                                                                                        |
| Description:           | Determines what percentage of the effective memory allocation limit is being consumed by the database table used for table-based audit logging. If this table grows too large, the availability of the database could be impacted. |
| Category:              | Memory                                                                                                                                                                                                                             |
| Unit:                  | percent                                                                                                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 5; 7; 9; 11                                                                                                                                                                                                  |
| User Action:           | Consider exporting the content of the table and then truncating the table.                                                                                                                                                         |
| Further information:   | SAP Note: 2081869 How to handle HANAAlert 64: 'Total memory usage of table-based audit log'                                                                                                                                        |
| ID:                    | 65                                                                                                                                                                                                                                 |
| Name:                  | Runtime of the log backups currently running                                                                                                                                                                                       |
| Description:           | Determines whether or not the most recent log backup terminates in the given time.                                                                                                                                                 |
| Category:              | Backup                                                                                                                                                                                                                             |
| Unit:                  | seconds                                                                                                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 30; 300; 900 Severity level(s): 2; 3; 4                                                                                                                                                                      |
| User Action:           | Investigate why the log backup runs for too long, and resolve the issue.                                                                                                                                                           |
| Further information:   | SAP HANAAdministration Guide, SAP Note: 2081845 How to handle HANAAlert 65: 'Runtime of the log backups currently running'                                                                                                         |
| ID:                    | 66                                                                                                                             |
|------------------------|--------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Storage snapshot is prepared                                                                                                   |
| Description:           | Determines whether or not the period, during which the database is prepared for a storage snapshot, exceeds a given threshold. |
| Category:              | Backup                                                                                                                         |
| Unit:                  | seconds                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 300; 900; 3600 Severity level(s): 2; 3; 4                                                                |
| User Action:           | Investigate why the storage snapshot was not confirmed or abandoned, and resolve the issue.                                    |
| Further information:   | SAP HANAAdministration Guide, SAP Note: 2081405 How to handle HANAAlert 66: 'Storage snapshot is prepared'                     |
| ID:                    | 67                                                                                                                             |
| Name:                  | Table growth of rowstore tables                                                                                                |
| Description:           | Determines the growth rate of rowstore tables                                                                                  |
| Category:              | Memory                                                                                                                         |
| Unit:                  | percent                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 5; 7.5; 10                                                                                               |
| User Action:           | Try to reduce the size of row store table by removing unused data                                                              |
| Further information:   | SAP Note: 2054411 How to handle Alert 67: 'Table growth of Row Store Tables'                                                   |
| ID:                    | 68                                                                                                                             |
| Name:                  | Total memory usage of row store                                                                                                |
| Description:           | Determines the current memory size of a row store used by a service                                                            |
| Category:              | Memory                                                                                                                         |
| Unit:                  | percent                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 70; 80; 90 Severity level(s): 2; 3; 4                                                                    |
| User Action:         | Investigate memory usage by row store tables and consider cleanup of unused data                                                   |
|----------------------|------------------------------------------------------------------------------------------------------------------------------------|
| Further information: | SAP Note: 2050579 How to handle HANAAlert 68: 'total memory usage of row store'                                                    |
| ID:                  | 69                                                                                                                                 |
| Name:                | Enablement of automatic log backup                                                                                                 |
| Description:         | Determines whether automatic log backup is enabled.                                                                                |
| Category:            | Backup                                                                                                                             |
| User Action:         | Enable automatic log backup. For more details please see SAP HANAAdministration Guide.                                             |
| Further information: | SAP Note: 2081360 Handle HANAAlert 69: Enablement of automatic log backup                                                          |
| ID:                  | 70                                                                                                                                 |
| Name:                | Consistency of internal system components after system upgrade                                                                     |
| Description:         | Verifies the consistency of schemas and tables in internal system components (for example, the repository) after a system upgrade. |
| Category:            | Availability                                                                                                                       |
| User Action:         | Contact SAP support.                                                                                                               |
| ID:                  | 71                                                                                                                                 |
| Name:                | Row store fragmentation                                                                                                            |
| Description:         | Check for fragmentation of row store.                                                                                              |
| Category:            | Memory                                                                                                                             |
| User Action:         | Implement SAP Note 1813245.                                                                                                        |
| Further information: | SAP Note: 1813245 Short dump when changing LC status                                                                               |
| ID:                  | 72                                                                                                                                 |
| Name:                | Number of log segments                                                                                                             |
| Description:         | Determines the number of log segments in the log volume of each serviceCheck for number of log segments.                           |
| Category:            | Backup                                                                                                                             |
| Unit:                | log segments                                                                                                                       |
| Thresholds / Severity:   | Default threshold(s): 5000; 7000; 9000 Severity level(s): 2; 3; 4                                                                                                                                                                                                                              |
|--------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| User Action:             | Make sure that log backups are being automatically created and that there is enough space available for them. Check whether the system has been frequently and unusually restarting services. If it has, then resolve the root cause of this issue and create log backups as soon as possible. |
| ID:                      | 73                                                                                                                                                                                                                                                                                             |
| Name:                    | Overflow of rowstore version space                                                                                                                                                                                                                                                             |
| Description:             | Determines the overflow ratio of the rowstore version space.                                                                                                                                                                                                                                   |
| Category:                | Memory                                                                                                                                                                                                                                                                                         |
| Unit:                    | ratio                                                                                                                                                                                                                                                                                          |
| Thresholds / Severity:   | Default threshold(s): 10; 50; 100 Severity level(s): 2; 3; 4                                                                                                                                                                                                                                   |
| User Action:             | This alert is deprecated. Please refer to alert 75 "Rowstore version space skew" for indica- tion of rowstore version accumulation                                                                                                                                                             |
| Further information:     | Transactional Problems [page 167]                                                                                                                                                                                                                                                              |
| ID:                      | 74                                                                                                                                                                                                                                                                                             |
| Name:                    | Overflow of metadata version space                                                                                                                                                                                                                                                             |
| Description:             | Determines the overflow ratio of the metadata version space.                                                                                                                                                                                                                                   |
| Category:                | Memory                                                                                                                                                                                                                                                                                         |
| Unit:                    | ratio                                                                                                                                                                                                                                                                                          |
| Thresholds / Severity:   | Default threshold(s): 10; 50; 100 Severity level(s): 2; 3; 4                                                                                                                                                                                                                                   |
| User Action:             | This alert is deprecated. Please refer to alert 75 "Rowstore version space skew" for indica- tion of rowstore version accumulation                                                                                                                                                             |
| Further information:     | Transactional Problems [page 167]                                                                                                                                                                                                                                                              |
| ID:                      | 75                                                                                                                                                                                                                                                                                             |
| Name:                    | Rowstore version space skew                                                                                                                                                                                                                                                                    |
| Description:           | Determines whether the rowstore version chain is too long.                                                                                                                                                                                                                                                                                                                                                                                                                       |
|------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Category:              | Memory                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| Unit:                  | versions                                                                                                                                                                                                                                                                                                                                                                                                                                                                         |
| Thresholds / Severity: | Default threshold(s): 10000; 100000; 1000000                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| User Action:           | Identify the connection or transaction that is blocking version garbage collection. You can do this in the SAP HANAstudio by executing "MVCC Blocker Statement" and "MVCC Blocker Transaction" available on the System Information tab of the Administration editor. If possible, kill the blocking connection or cancel the blocking transaction. For your infor- mation, you can find table information by using query "SELECT*FROMTABLESWHERE TABLE_OID = <table object ID>". |
| Further information:   | Transactional Problems [page 167]                                                                                                                                                                                                                                                                                                                                                                                                                                                |
| ID:                    | 76                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Name:                  | Discrepancy between host server times                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Description:           | Identifies discrepancies between the server times of hosts in a scale-out system.                                                                                                                                                                                                                                                                                                                                                                                                |
| Category:              | Configuration                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| Unit:                  | minutes                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |
| Thresholds / Severity: | Default threshold(s): 1; 2; 3                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| User Action:           | Check operating system time settings.                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| ID:                    | 77                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Name:                  | Database disk usage                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
| Description:           | Determines the total used disk space of the database. All data, logs, traces and backups are considered.                                                                                                                                                                                                                                                                                                                                                                         |
| Category:              | Disk                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Unit:                  | GB                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Thresholds / Severity: | Default threshold(s): 300; 400; 500 Severity level(s): 2; 3; 4                                                                                                                                                                                                                                                                                                                                                                                                                   |
| User Action:           | Investigate the disk usage of the database. See system view M_DISK_USAGE for more details.                                                                                                                                                                                                                                                                                                                                                                                       |
| ID:                    | 78                                                                                                                                                                                                                                                                   |
|------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Connection between systems in system replication setup                                                                                                                                                                                                               |
| Description:           | Identifies closed connections between the primary system and a secondary system. If connections are closed, the primary system is no longer being replicated.                                                                                                        |
| Category:              | Availability                                                                                                                                                                                                                                                         |
| User Action:           | Investigate why connections are closed (for example, network problem) and resolve the issue.                                                                                                                                                                         |
| Further information:   | SAP HANAAdministration Guide                                                                                                                                                                                                                                         |
| ID:                    | 79                                                                                                                                                                                                                                                                   |
| Name:                  | Configuration consistency of systems in system replication setup                                                                                                                                                                                                     |
| Description:           | Identifies configuration parameters that do not have the same value on the primary system and a secondary system. Most configuration parameters should have the same value on both systems because the secondary system has to take over in the event of a disaster. |
| Category:              | Configuration                                                                                                                                                                                                                                                        |
| User Action:           | If the identified configuration parameter(s) should have the same value in both systems, adjust the configuration. If different values are acceptable, add the parameter(s) as an exception in global.ini/[inifile_checker].                                         |
| Further information:   | SAP HANAAdministration Guide                                                                                                                                                                                                                                         |
| ID:                    | 80                                                                                                                                                                                                                                                                   |
| Name:                  | Availability of table replication                                                                                                                                                                                                                                    |
| Description:           | Monitors error messages related to table replication.                                                                                                                                                                                                                |
| Category:              | Availability                                                                                                                                                                                                                                                         |
| Unit:                  | number of deactivated tables                                                                                                                                                                                                                                         |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 4                                                                                                                                                                                                                         |
| User Action:           | Determine which tables encountered the table replication error using system view M_TA- BLE_REPLICAS, and then check the corresponding indexserver alert traces.                                                                                                      |
| ID:                    | 81                                                                                                                                                                                                                                                                   |
| Name:                  | Cached view size                                                                                                                                                                                                                                                     |
| Description:           | Determines how much memory is occupied by cached view                                                                                              |
|------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------|
| Category:              | Memory                                                                                                                                             |
| Unit:                  | percent                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 50; 75; 90 Severity level(s): 1; 2; 3                                                                                        |
| User Action:           | Increase the size of the cached view. In the "result_cache" section of the indexserver.ini file, increase the value of the "total_size" parameter. |
| ID:                    | 82                                                                                                                                                 |
| Name:                  | Timezone conversion                                                                                                                                |
| Description:           | Compares SAP HANAinternal timezone conversion with Operating System timezone con- version.                                                         |
| Category:              | Configuration                                                                                                                                      |
| Unit:                  | days                                                                                                                                               |
| Thresholds / Severity: | Default threshold(s): 999999999; 100; 10 Severity level(s): 2; 3; 4                                                                                |
| User Action:           | Update SAP HANAinternal timezone tables (refer to SAP note 1932132).                                                                               |
| Further information:   | SAP Note: 1932132 Large Time Difference Between Application ServerandSAPHANA Database                                                              |
| ID:                    | 83                                                                                                                                                 |
| Name:                  | Table consistency                                                                                                                                  |
| Description:           | Reports the number of inconsistencies detected by the latest consistency check runs.                                                               |
| Category:              | Availability                                                                                                                                       |
| Unit:                  | errors                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 1; 3; 4 Severity level(s): 1; 3; 4                                                                                           |
| User Action:           | Contact SAP support.                                                                                                                               |
| Further information:   | SAP Note: 2881922 - How to Handle HANAAlert 83 : 'Alert Table consistency' SAP Note: 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions NOTE: Rationale for the alert interval (300 seconds / 5 minutes) vs. the collector inter- val (1 day): "... the intention is to generate the alert shortly after the inconsistency was detected without having any synchronization between collector and alert. Then it is about the maximum delay we want to accept between detection of an inconsistency and the alert generation."   |
|------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| ID:                    | 84                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| Name:                  | Insecure instance SSFS encryption configuration                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Description:           | Determines whether the master key of the instance secure store in the file system (SSFS) of your SAP HANAsystem has been changed. If the SSFS master key is not changed after installation, it cannot be guaranteed that the initial key is unique.                                                                                                                                                                                                                                                                                    |
| Category:              | Security                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| User Action:           | Change the instance SSFS master key as soon as possible.                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Further information:   | SAP HANAAdministration Guide                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| ID:                    | 85                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| Name:                  | Insecure systemPKI SSFS encryption configuration                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| Description:           | Determines whether the master key of the secure store in the file system (SSFS) of your system's internal public key infrastructure (system PKI) has been changed. If the SSFS master key is not changed after installation, it cannot be guaranteed that the initial key is unique.                                                                                                                                                                                                                                                   |
| Category:              | Security                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| User Action:           | Change the system PKI SSFS master key as soon as possible.                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
| Further information:   | SAP HANAAdministration Guide                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |
| ID:                    | 86                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| Name:                  | Internal communication is configured too openly                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        |
| Description:           | Determines whether the ports used by SAP HANAfor internal communication are securely configured. If the "listeninterface" property in the "communication" section of the global.ini file does not have the value ".local" for single-host systems and ".all" or ".global" for multi- ple-host systems, internal communication channels are externally exploitable.                                                                                                                                                                     |
| Category:              | Security                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| User Action:           | The parameter [communication] listeninterface in global.ini is not set to a secure value. Please refer to SAP Note 2183363 or the section on internal host name resolution in the SAP HANAMaster Guide.   |
|------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Further information:   | SAP Note: 2183363 Configuration of SAP HANAinternal network                                                                                                                                               |
| ID:                    | 87                                                                                                                                                                                                        |
| Name:                  | Granting of SAP HANADI support privileges                                                                                                                                                                 |
| Description:           | Determines if support privileges for the SAP HANADeployment Infrastructure (DI) are currently granted to any database users or roles.                                                                     |
| Category:              | Security                                                                                                                                                                                                  |
| Unit:                  | users                                                                                                                                                                                                     |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 2                                                                                                                                                              |
| User Action:           | Check if the corresponding users still need the privileges. If not, revoke the privileges from them.                                                                                                      |
| ID:                    | 88                                                                                                                                                                                                        |
| Name:                  | Auto merge for column-store tables                                                                                                                                                                        |
| Description:           | Determines if the delta merge of a table was executed successfully or not.                                                                                                                                |
| Category:              | Memory                                                                                                                                                                                                    |
| Unit:                  | records                                                                                                                                                                                                   |
| Thresholds / Severity: | Default threshold(s): 1; 5; 10 Severity level(s): 2; 3; 4                                                                                                                                                 |
| User Action:           | The delta merge was not executed successfully for a table. Check the error description in view M_DELTA_MERGE_STATISTICS and also Indexserver trace.                                                       |
| ID:                    | 89                                                                                                                                                                                                        |
| Name:                  | Missing volume files                                                                                                                                                                                      |
| Description:           | Determines if there is any volume file missing.                                                                                                                                                           |
| Category:              | Configuration                                                                                                                                                                                             |
| User Action:           | Volume file missing, database instance is broken, stop immediately all operations on this instance.                                                                                                         |
|------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| ID:                    | 91                                                                                                                                                                                                          |
| Name:                  | Plan cache hit ratio                                                                                                                                                                                        |
| Description:           | Determines whether or not the plan cache hit ratio is too low.                                                                                                                                              |
| Category:              | Memory                                                                                                                                                                                                      |
| Unit:                  | ratio                                                                                                                                                                                                       |
| Thresholds / Severity: | Default threshold(s): 0.95; 0.90 Severity level(s): 1;2                                                                                                                                                     |
| User Action:           | Increase the size of the plan cache. In the "sql" section of the indexserver.ini file, increase the value of the "plan_cache_size" parameter.                                                               |
| ID:                    | 92                                                                                                                                                                                                          |
| Name:                  | Root keys of persistent services are not properly synchronized                                                                                                                                              |
| Description:           | Not all services that persist data could be reached the last time the root key change of the data volume encryption service was changed. As a result, at least one service is running with an old root key. |
| Category:              | Security                                                                                                                                                                                                    |
| User Action:           | Trigger a savepoint for this service or flush the SSFS cache using hdbcons                                                                                                                                  |
| ID:                    | 93                                                                                                                                                                                                          |
| Name:                  | Streaming License expiry                                                                                                                                                                                    |
| Description:           | Determines how many days until your streaming license expires. Once your license expires, you can no longer start streaming projects.                                                                       |
| Category:              | Availability                                                                                                                                                                                                |
| Unit:                  | day                                                                                                                                                                                                         |
| Thresholds / Severity: | Default threshold(s): 30; 14 ; 7 Severity level(s): 2; 3; 4                                                                                                                                                 |
| User Action:           | Obtain a valid license and install it. For the exact expiration date, see the monitoring view M_LICENSES.                                                                                                   |
| ID:                    | 94                                                                                                                                                                                                                                              |
|------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Log replay backlog for system replication secondary                                                                                                                                                                                             |
| Description:           | System Replication secondary site has a higher log replay backlog than expected.                                                                                                                                                                |
| Category:              | Availability                                                                                                                                                                                                                                    |
| Unit:                  | MB                                                                                                                                                                                                                                              |
| Thresholds / Severity: | Default threshold(s): 10240; 51200; 512000 Severity level(s): 2; 3; 4                                                                                                                                                                           |
| User Action:           | Investigate on secondary site, why log replay backlog is increased                                                                                                                                                                              |
| ID:                    | 95                                                                                                                                                                                                                                              |
| Name:                  | Availability of Data Quality reference data (directory files)                                                                                                                                                                                   |
| Description:           | Determine the Data Quality reference data expiration dates.                                                                                                                                                                                     |
| Category:              | Availability                                                                                                                                                                                                                                    |
| Unit:                  | day                                                                                                                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 30; 7 ; 1 Severity level(s): 2; 3; 4                                                                                                                                                                                      |
| User Action:           | Download the latest Data Quality reference data files and update the system. (For more details about updating the directories, see the Installation and Configuration Guide for SAP HANASmart Data Integration and SAP HANASmart Data Quality.) |
| Further information:   | SAP HANAAdministration Guide                                                                                                                                                                                                                    |
| ID:                    | 96                                                                                                                                                                                                                                              |
| Name:                  | Long-running tasks                                                                                                                                                                                                                              |
| Description:           | Identifies all long-running tasks.                                                                                                                                                                                                              |
| Category:              | Availability                                                                                                                                                                                                                                    |
| Unit:                  | seconds                                                                                                                                                                                                                                         |
| Thresholds / Severity: | Default threshold(s): 3600; 21600; 43200 Severity level(s): 2; 3; 4                                                                                                                                                                             |
| User Action:           | Investigate the long-running tasks. For more information, see the task statistics tables or views in _SYS_TASK schema and trace log.                                                                                                            |
ID:
97
| Name:                  | Granting of SAP HANADI container import privileges                                                                                                                                                           |
|------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Description:           | Determines if the container import feature of the SAP HANADeployment Infrastructure (DI) is enabled and if import privileges for SAP HANADI containers are currently granted to any database users or roles. |
| Category:              | Security                                                                                                                                                                                                     |
| Unit:                  | users                                                                                                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 3                                                                                                                                                                 |
| User Action:           | Check if the identified users still need the privileges. If not, revoke the privileges from them and disable the SAP HANADI container import feature.                                                        |
| ID:                    | 98                                                                                                                                                                                                           |
| Name:                  | LOB garbage collection activity                                                                                                                                                                              |
| Description:           | Determines whether or not the lob garbage collection is activated.                                                                                                                                           |
| Category:              | Configuration                                                                                                                                                                                                |
| User Action:           | Activate the LOB garbage collection using the corresponding configuration parameters.                                                                                                                        |
| ID:                    | 99                                                                                                                                                                                                           |
| Name:                  | HANAversion                                                                                                                                                                                                  |
| Description:           | Checks the installed HANAversion.                                                                                                                                                                            |
| Category:              | Configuration                                                                                                                                                                                                |
| Unit:                  | support package                                                                                                                                                                                              |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 1                                                                                                                                                                 |
| User Action:           | Please check if your SAP HANAsystem can be upgraded to a newer version.                                                                                                                                      |
| ID:                    | 101                                                                                                                                                                                                          |
| Name:                  | SQL access for SAP HANADI technical users                                                                                                                                                                    |
| Description:           | Determines if SQL access has been enabled for any SAP HANADI technical users. SAP HANADI technical users are either users whose names start with '_SYS_DI' or SAP HANADI container technical users (<container name>, <container name>#DI, <container name>#OO).   |
|------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Category:              | Security                                                                                                                                                                                                                                                           |
| Unit:                  | users                                                                                                                                                                                                                                                              |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 2                                                                                                                                                                                                                       |
| User Action:           | Check if the identified users ('_SYS_DI*' users or SAP HANADI container technical users) still need SQL access. If not, disable SQL access for these users and deactivate the users.                                                                               |
| ID:                    | 102                                                                                                                                                                                                                                                                |
| Name:                  | Existence of system database backup                                                                                                                                                                                                                                |
| Description:           | Determines whether or not a system database backup exists. Without a system database backup, your system cannot be recovered.                                                                                                                                      |
| Category:              | Backup                                                                                                                                                                                                                                                             |
| User Action:           | Perform a backup of the system database as soon as possible.                                                                                                                                                                                                       |
| ID:                    | 103                                                                                                                                                                                                                                                                |
| Name:                  | Usage of deprecated features                                                                                                                                                                                                                                       |
| Description:           | Determines if any deprecated features were used in the last interval.                                                                                                                                                                                              |
| Category:              | 0                                                                                                                                                                                                                                                                  |
| Unit:                  | calls                                                                                                                                                                                                                                                              |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 2                                                                                                                                                                                                                       |
| User Action:           | Check the view M_FEATURE_USAGE to see which features were used. Refer to SAP Note 2425002 for further information.                                                                                                                                                 |
| Further information:   | SAP Note: 2425002 SAP HANA2.0: Deprecations reported by the HANAstatistics server                                                                                                                                                                                  |
| ID:                    | 104                                                                                                                                                                                                                                                                |
| Name:                  | Log shipping backlog for system replication secondary                                                                                                                                                                                                              |
| Description:           | System Replication secondary site has a higher log shipping backlog than expected.                                                                |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------|
| Category:              | Availability                                                                                                                                      |
| Unit:                  | MB                                                                                                                                                |
| Thresholds / Severity: | Default threshold(s): 1024; 10240; 51200 Severity level(s): 2; 3; 4                                                                               |
| User Action:           | Investigate on primary and secondary site, why log shipping backlog is increased                                                                  |
| ID:                    | 105                                                                                                                                               |
| Name:                  | Total Open Transactions Check                                                                                                                     |
| Description:           | The check monitors the number of open transactions per service                                                                                    |
| Category:              | Sessions/Transactions                                                                                                                             |
| Unit:                  | percent                                                                                                                                           |
| Thresholds / Severity: | Default threshold(s): 20; 50; 80 Severity level(s): 2; 3; 4                                                                                       |
| User Action:           | Double check if the application is closing the connection correctly, and whether the high transaction load on the system is expected.             |
| ID:                    | 106                                                                                                                                               |
| Name:                  | ASYNC replication in-memory buffer overflow                                                                                                       |
| Description:           | Checks if local in-memory buffer in ASYNC replication mode runs full                                                                              |
| Category:              | Availability                                                                                                                                      |
| User Action:           | Check buffer size, peak loads, network, IO on secondary                                                                                           |
| ID:                    | 109                                                                                                                                               |
| Name:                  | Backup history broken                                                                                                                             |
| Description:           | If the backup history is broken, the log_mode is internally set to overwrite, it is not ensured that the service is fully recoverable via backup. |
| Category:              | Backup                                                                                                                                            |
| User Action:           | Perform a data backup as soon as possible to ensure that the service is fully recoverable.                                                        |
| ID:                    | 110                                                                                                                                                                                                                                                                                                                |
|------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Catalog Consistency                                                                                                                                                                                                                                                                                                |
| Description:           | Identifies the number of errors and affected objects detected by _SYS_STATISTICS.Collec- tor_Global_Catalog_Consistency.                                                                                                                                                                                           |
| Category:              | Availability                                                                                                                                                                                                                                                                                                       |
| Unit:                  | errors                                                                                                                                                                                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 1; 3; 4 Severity level(s): 1; 3; 4                                                                                                                                                                                                                                                           |
| User Action:           | Contact SAP support.                                                                                                                                                                                                                                                                                               |
| ID:                    | 111                                                                                                                                                                                                                                                                                                                |
| Name:                  | Replication status of Replication Log                                                                                                                                                                                                                                                                              |
| Description:           | Check whether the status of replication log is disabled.                                                                                                                                                                                                                                                           |
| Category:              | Availability                                                                                                                                                                                                                                                                                                       |
| User Action:           | Truncate replication log table and enable replication log.                                                                                                                                                                                                                                                         |
| ID:                    | 113                                                                                                                                                                                                                                                                                                                |
| Name:                  | Host open file count                                                                                                                                                                                                                                                                                               |
| Description:           | Determines what percentage of total open file handles are in use. All processes are considered, including non-SAP HANAprocesses. Compare M_HOST_RESOURCE_UTI- LIZATION.OPEN_FILE_COUNT with M_HOST_INFORMATION.VALUE of M_HOST_INFOR- MATION.KEY open_file_limit.                                                  |
| Category:              | Configuration                                                                                                                                                                                                                                                                                                      |
| Unit:                  | percent                                                                                                                                                                                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 95; 98; 100 Severity level(s): 2; 3; 4                                                                                                                                                                                                                                                       |
| User Action:           | This is normal behavior and neither a SAP HANAnor a Linux issue. 1. Check the current maximum number of allowed file handles: cat /proc/sys/fs/ file-max 2. Extend maximum number of file handles in /etc/sysctl.conf: fs.file-max = 20000000 3. Activate changes for operating system: sysctl -p /etc/sysctl.conf |
ID:
114
| Name:                  | Host active async io count                                                                                                                                                                                                                                                                                          |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Description:           | Determines what percentage of total asynchronous input/output requests are in use. All processes are considered, including non-SAP HANAprocesses. Compare M_HOST_RE- SOURCE_UTILIZATION.ACTIVE_ASYNC_IO_COUNT with M_HOST_INFORMATION.VALUE of M_HOST_INFORMATION.KEY async_io_limit.                               |
| Category:              | Configuration                                                                                                                                                                                                                                                                                                       |
| Unit:                  | percent                                                                                                                                                                                                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 95; 98; 100 Severity level(s): 2; 3; 4                                                                                                                                                                                                                                                        |
| User Action:           | See SAP Note 1868829                                                                                                                                                                                                                                                                                                |
| Further information:   | SAP Note: 1868829 Startup Issues Because Number of Active I/O Requests to Queue Exceeds aio-max-nr Limit                                                                                                                                                                                                            |
| ID:                    | 115                                                                                                                                                                                                                                                                                                                 |
| Name:                  | Timezone environment variable verification                                                                                                                                                                                                                                                                          |
| Description:           | Determines if the timezone environment variable TZ can be interpreted. See M_TIME- ZONE_ALERTS. Otherwise HANAfalls back to a system call which can cause significant performance issues.                                                                                                                           |
| Category:              | Configuration                                                                                                                                                                                                                                                                                                       |
| User Action:           | Please set the timezone environment variable TZ to a valid value according to the POSIX documentation and restart the HANAdatabase. See also SAP Note 2100040.                                                                                                                                                      |
| Further information:   | SAP Note: 2100040 FAQ:SAPHANACPU                                                                                                                                                                                                                                                                                    |
| ID:                    | 117                                                                                                                                                                                                                                                                                                                 |
| Name:                  | Record count of non-partitioned column-store tables (include)                                                                                                                                                                                                                                                       |
| Description:           | Determines the number of records in non-partitioned column-store tables (only include tables are checked). Current table size may not be critical. Partitioning need only be consid- ered if tables are expected to grow rapidly (a non-partitioned table cannot contain more than 2,147,483,648 (2 billion) rows). |
| Category:              | Memory                                                                                                                                                                                                                                                                                                              |
| Unit:                  | records                                                                                                                                                                                                                                                                                                             |
| Thresholds / Severity:   | Default threshold(s): 300000000 Severity level(s): 1                                                                                                                                    |
|--------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| User Action:             | Consider partitioning the table only if you expect it to grow rapidly.                                                                                                                  |
| ID:                      | 126                                                                                                                                                                                     |
| Name:                    | Check availability of remote table replicaion                                                                                                                                           |
| Description:             | Monitor whether the replication status of RTR tables has turned to be DISABLED.                                                                                                         |
| Category:                | Availability                                                                                                                                                                            |
| User Action:             | Check error message with a view M_REMOTE_TABLE_REPLICAS                                                                                                                                 |
| ID:                      | 127                                                                                                                                                                                     |
| Name:                    | Record count of column-store table partitions (include)                                                                                                                                 |
| Description:             | Determines the number of records in the partitions of column-store tables (only include tables are checked). A table partition cannot contain more than 2,147,483,648 (2 billion) rows. |
| Category:                | Memory                                                                                                                                                                                  |
| Unit:                    | records                                                                                                                                                                                 |
| Thresholds / Severity:   | Default threshold(s): 1500000000; 1800000000; 1900000000 Severity level(s): 2; 3; 4                                                                                                     |
| User Action:             | Consider repartitioning the table.                                                                                                                                                      |
| ID:                      | 128                                                                                                                                                                                     |
| Name:                    | LDAP Enabled Users without SSL                                                                                                                                                          |
| Description:             | Checks for the vulnerability where users may be enabled for LDAP Authentication but SSL is not enabled for the communication from HANAclient (odbc/jdbc/hdbsql) to the HANADB.          |
| Category:                | Security                                                                                                                                                                                |
| User Action:             | Configure SSL to reduce risk of man-in-the-middle attacks and privacy protection.                                                                                                       |
| Further information:   | The alert is triggered when any user in view SYS.USERS is enabled for LDAP by having IS_LDAP_ENABLED set to 'TRUE' and the communication from HANAclient (odbc/jdbc/ hdbsql) to the HANADBis not encrypted: global.ini [communication] ssl=off. The alert is not relevant for connections from HANADBtothe LDAP directory server. See: Server-Side TLS/SSL Configuration Properties for Internal Communication (SAP HANASecurity Guide for SAP HANAPlatform)   |
|------------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| ID:                    | 129                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Name:                  | Check trusted certificate expiration date                                                                                                                                                                                                                                                                                                                                                                                                                      |
| Description:           | Determines if there are any trusted certificates that will expire soon or have already expired. The trusting certificate collection must have a purpose set.                                                                                                                                                                                                                                                                                                   |
| Category:              | Security                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| Unit:                  | day                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 30 Severity level(s): 3                                                                                                                                                                                                                                                                                                                                                                                                                  |
| User Action:           | Replace the certificates.                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| ID:                    | 130                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Name:                  | Check own certificate expiration date                                                                                                                                                                                                                                                                                                                                                                                                                          |
| Description:           | Determines if there are any own or chain certificates that will expire soon or have already expired. The owning certificate collection must have a purpose set.                                                                                                                                                                                                                                                                                                |
| Category:              | Security                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
| Unit:                  | day                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 30; 14 Severity level(s): 3; 4                                                                                                                                                                                                                                                                                                                                                                                                           |
| User Action:           | Replace the certificates.                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| ID:                    | 131                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Name:                  | Session requests queued by admission control                                                                                                                                                                                                                                                                                                                                                                                                                   |
| Description:           | Determines the number of session requests waiting in the admission control queue. This can indicate an issue with the response time of the request.                                                                                                                                                                                                                                                                                                            |
| Category:              | Availability                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| Unit:                  | count                                                                                                                                                                                                                                |
|------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 4                                                                                                                                                                                         |
| User Action:           | Investigate why the session requests newly queued by admission control. Refer to M_AD- MISSION_CONTROL_EVENTS for more information.                                                                                                  |
| ID:                    | 132                                                                                                                                                                                                                                  |
| Name:                  | Session requests rejected by admission control                                                                                                                                                                                       |
| Description:           | Determines the number of session requests newly rejected by admission control. This can indicate an issue with the availability of the database.                                                                                     |
| Category:              | Availability                                                                                                                                                                                                                         |
| Unit:                  | count                                                                                                                                                                                                                                |
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 4                                                                                                                                                                                         |
| User Action:           | Investigate why the session requests newly rejected by admission control. Refer to M_AD- MISSION_CONTROL_EVENTS for more information.                                                                                                |
| ID:                    | 133                                                                                                                                                                                                                                  |
| Name:                  | Check out-of-buffers event for a buffer cache                                                                                                                                                                                        |
| Description:           | Checks whether a buffer cache is sufficiently configured. An out-of-buffers event indicates that the affected buffer cache is insufficiently configured for the current workload. It should be resolved, otherwise queries may fail. |
| Category:              | Configuration                                                                                                                                                                                                                        |
| User Action:           | Resolve the out-of-buffers event by increasing the max_size parameter of the affected buffer cache.                                                                                                                                  |
| ID:                    | 134                                                                                                                                                                                                                                  |
| Name:                  | Administration of SAP HANADI user groups by user administrators                                                                                                                                                                      |
| Description:           | Determines if any SAP HANADI user groups can be managed by a user with the USER ADMIN system privilege. SAP HANADI user groups are user groups whose names start with '_SYS_DI#'.                                                    |
| Category:              | Security                                                                                                                                                                                                                             |
| Unit:                  | user groups                                                                                                                                                                                                                                             |
|------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Thresholds / Severity: | Default threshold(s): 1 Severity level(s): 2                                                                                                                                                                                                            |
| User Action:           | Verify that the identified user groups still need to be able to be managed by users with the USER ADMIN system privilege. If they don't, disable USER ADMIN administration for these user groups (ALTER USERGROUP <usergroup_name> DISABLE USER ADMIN). |
| ID:                    | 136                                                                                                                                                                                                                                                     |
| Name:                  | Unsupported configuration parameter values                                                                                                                                                                                                              |
| Description:           | Checks if configuration parameters are set to unsupported values                                                                                                                                                                                        |
| Category:              | Configuration                                                                                                                                                                                                                                           |
| User Action:           | Check if system is running in a supported state                                                                                                                                                                                                         |
| ID:                    | 137                                                                                                                                                                                                                                                     |
| Name:                  | Restart required after configuration change                                                                                                                                                                                                             |
| Description:           | Checks if services require a restart after a configuration was changed                                                                                                                                                                                  |
| Category:              | Configuration                                                                                                                                                                                                                                           |
| User Action:           | Restart services (see M_CONFIGURATION_PARAMETER_VALUES) to allow the changed configuration to become active.                                                                                                                                            |
| ID:                    | 140                                                                                                                                                                                                                                                     |
| Name:                  | License Usage Type in Production System                                                                                                                                                                                                                 |
| Description:           | Checks that property license_usage in section system_information is not unde- fined when property usage in section system_information is set to production in global.ini.                                                                               |
| Category:              | Configuration                                                                                                                                                                                                                                           |
| User Action:           | Set property license_usage in section system_information for production sys- tems.                                                                                                                                                                      |
| ID:                    | 141                                                                                                                                                                                                                                                     |
| Name:                  | Checking system logging is enabled.                                                                                                                                                                                                                     |
| Description:         | While logging is disabled, no log entries persist; only the data area is written when a save- point is reached. This behavior can cause the loss of committed transactions when the indexserver terminates in the middle of a LOAD operation. In case of a termination, truncate and insert all data again.                                                              |
|----------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Category:            | Configuration                                                                                                                                                                                                                                                                                                                                                            |
| User Action:         | Enable system logging with ALTER SYSTEM LOGGING ON; and perform a savepoint.                                                                                                                                                                                                                                                                                             |
| ID:                  | 143                                                                                                                                                                                                                                                                                                                                                                      |
| Name:                | Enable automatic log backup fallback for third-party backup tools                                                                                                                                                                                                                                                                                                        |
| Description:         | Indicates the following: • Automatic log backup fallback is enabled. • Log backup fallback is activated. Log backups are being written to the file system instead of to the external storage system.                                                                                                                                                                     |
| Category:            | Backup and Recovery                                                                                                                                                                                                                                                                                                                                                      |
| User Action:         | The external storage system appears to be unavailable, as log backups are being written to a fallback destination in the file system. User action: • Check whether the external storage system is unavailable due to a planned downtime. • Otherwise, investigate why the external storage system is not available.                                                      |
| Further Information: | SAP HANAAdministration Guide Backup and Recovery > Automatic Log Backup Fallback for Third-Party Backup Tools                                                                                                                                                                                                                                                            |
| ID:                  | 144                                                                                                                                                                                                                                                                                                                                                                      |
| Name:                | Checks if table logging is disabled                                                                                                                                                                                                                                                                                                                                      |
| Description:         | While table logging is disabled, no DMLspecific log entries are persisted: only the tables data area is written when a savepoint is reached. This behavior might cause data loss of committed DMLtransactions when these tables need to be recovered (including system replication). In such a case table needs to be truncated and all data needs to be inserted again. |
| Category:            | Configuration                                                                                                                                                                                                                                                                                                                                                            |
| User Action:         | Enable table logging with ALTER TABLE ... ENABLE DELTA LOG.                                                                                                                                                                                                                                                                                                              |
| Further Information: | SAP Note: 1999930 FAQ: SAP HANAI/O Analysis                                                                                                                                                                                                                                                                                                                              |
| ID:                  | 145                                                                                                                                                                                                                                                                                                                                                                      |
| Name:                | Nameserver Topology Inconsistencies                                                                                                                                                                                                                                                                                                                                      |
| Description:           | This alert checker evaluates the landscape topology defined on the SYSTEMDB (Name- server). If inconsistencies are found then a warning alert is raised.                                                                                                                                                                                 |
|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| User Action:           | Contact SAP support.                                                                                                                                                                                                                                                                                                                     |
| Further Information:   | SAP Note: 3246723 - How to handle HANAAlert 145: Nameserver Topology Inconsisten- cies                                                                                                                                                                                                                                                   |
| ID:                    | 146                                                                                                                                                                                                                                                                                                                                      |
| Name:                  | Table Consistency Status                                                                                                                                                                                                                                                                                                                 |
| Description:           | Checks the view CONSISTENCY_CHECK_HISTORY_ERRORS and reports the number of errors in tables with inconsistencies. Severity ERROR is reported as a MEDIUM level alert, Severity HIGH is reported as a HIGH level alert. See also Alert 83 which only triggers an alert if errors are found and there is a change in the number of errors. |
| Category:              | Availability                                                                                                                                                                                                                                                                                                                             |
| Unit:                  | errors                                                                                                                                                                                                                                                                                                                                   |
| User Action:           | Contact SAP support.                                                                                                                                                                                                                                                                                                                     |
| Further Information:   | SAP Note: 2116157 - FAQ: SAP HANAConsistency Checks and Corruptions                                                                                                                                                                                                                                                                      |
| ID:                    | 148                                                                                                                                                                                                                                                                                                                                      |
| Name:                  | TLS not configured for external communication (ODBC/JDBC)                                                                                                                                                                                                                                                                                |
| Description:           | The SQL Port for external communication of ODBC/JDBC connections is not properly con- figured for TLS. Secured connections are not possible.                                                                                                                                                                                             |
| Category:              | Security                                                                                                                                                                                                                                                                                                                                 |
| User Action:           | Configure TLS for external communication by creating a certificate collection with the pur- pose SSL and providing a certificate. See section 'HANA Server setup forODBC/JDBC (HANA Studio, Client &HANA2Cockpit) connections' of SAP Note 2487639.                                                                                      |
| Further Information:   | SAP Note: 2487639 How-To Series - HANAand SSL / TLS                                                                                                                                                                                                                                                                                      |
| ID:                    | 151                                                                                                                                                                                                                                                                                                                                      |
| Name:                  | HANA/KMSfailed connection situation                                                                                                                                                                                                                                                                                                      |
| Description:           | Identifies a HANAconnectivity issue between the local secure store (LSS) and an external key management system (KMS).                                                                                                                                                                                                                    |
| Category:              | Security, security key management                                                                                                                                                                                                                                                                                                        |
| Thresholds / Severity: | Default threshold(s): 5 minutes; 30 minutes; 180 minutes Severity level(s): 2; 3; 4                                                                                                                                                                                                                                                      |
| User Action:           | Report external incident.                                                         |
|------------------------|-----------------------------------------------------------------------------------|
| Further Information:   | SAP Note: 3460034 Troubleshoot: HANA/KMSConnection Failure Alert                  |
| ID:                    | 500                                                                               |
| Name:                  | Dbspace usage                                                                     |
| Description:           | Checks for the dbspace size usage.                                                |
| Category:              | Disk                                                                              |
| Unit:                  | percent                                                                           |
| Thresholds / Severity: | Default threshold(s): 90; 95; 98 Severity level(s): 2; 3; 4                       |
| User Action:           | Investigate the usage of dbspace and increase the size.                           |
| ID:                    | 501                                                                               |
| Name:                  | Dbspace status                                                                    |
| Description:           | Determines whether or not all dbspaces are available.                             |
| Category:              | Availability                                                                      |
| User Action:           | Investigate why the dbspace is not available.                                     |
| ID:                    | 502                                                                               |
| Name:                  | Dbspace file status                                                               |
| Description:           | Determines whether or not all dbspace files are available.                        |
| Category:              | Availability                                                                      |
| User Action:           | Investigate why the dbspace file is not available.                                |
| ID:                    | 504                                                                               |
| Name:                  | DT Version mismatch                                                               |
| Description:           | Checks that dynamic tiering and SAP HANAversions match.                           |
| Category:              | Availability                                                                      |
| User Action:           | Check the reason for the mismatch, and correct the problem. See SAP Note 2637835. |
| Further information:   | SAP Note: 2637835 Dynamic Tiering Version does not Match SAP HANAVersion                                                   |
|------------------------|----------------------------------------------------------------------------------------------------------------------------|
| ID:                    | 505                                                                                                                        |
| Name:                  | ES backup history broken                                                                                                   |
| Description:           | If the backup history is broken, the service is not fully recoverable via backup.                                          |
| Category:              | Backup                                                                                                                     |
| User Action:           | Perform a data backup as soon as possible to ensure that the service is fully recoverable.                                 |
| ID:                    | 600                                                                                                                        |
| Name:                  | Inactive Streaming applications                                                                                            |
| Description:           | Identifies inactive Streaming applications.                                                                                |
| Category:              | Availability                                                                                                               |
| Unit:                  | seconds                                                                                                                    |
| Thresholds / Severity: | Default threshold(s): 60 Severity level(s): 4                                                                              |
| User Action:           | Investigate why the Streaming application is inactive, for example, by checking the Stream- ing application's trace files. |
| ID:                    | 601                                                                                                                        |
| Name:                  | Inactive Streaming project managed adapters                                                                                |
| Description:           | Identifies inactive Streaming project managed adapters.                                                                    |
| Category:              | Availability                                                                                                               |
| Unit:                  | seconds                                                                                                                    |
| Thresholds / Severity: | Default threshold(s): 60 Severity level(s): 4                                                                              |
| User Action:           | Investigate why the Streaming project managed adapter is inactive, for example, by check- ing the trace files.             |
| ID:                    | 602                                                                                                                        |
| Name:                  | Streaming project physical memory usage                                                                                    |
| Description:           | Determines what percentage of total physical memory available on the host is used for the streaming project.                        |
|------------------------|-------------------------------------------------------------------------------------------------------------------------------------|
| Category:              | Memory                                                                                                                              |
| Unit:                  | percent                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 80; 85; 90 Severity level(s): 2; 3; 4                                                                         |
| User Action:           | Investigate memory usage of the streaming project.                                                                                  |
| ID:                    | 603                                                                                                                                 |
| Name:                  | Streaming project CPU usage                                                                                                         |
| Description:           | Determines the percentage CPU usage for a streaming project on the host and therefore whether or not CPU resources are running out. |
| Category:              | CPU                                                                                                                                 |
| Unit:                  | percent                                                                                                                             |
| Thresholds / Severity: | Default threshold(s): 80; 90; 95 Severity level(s): 2; 3; 4                                                                         |
| User Action:           | Investigate CPU usage.                                                                                                              |
| ID:                    | 604                                                                                                                                 |
| Name:                  | Number of publishers of streaming project                                                                                           |
| Description:           | Identify the large publishers of streaming project. Make sure that they will not break the streaming project.                       |
| Category:              | Configuration                                                                                                                       |
| Unit:                  | count                                                                                                                               |
| Thresholds / Severity: | Default threshold(s): 100000 ;1000000; 10000000 Severity level(s): 2; 3; 4                                                          |
| User Action:           | Investigate whether these publishers are created intentionally.                                                                     |
| ID:                    | 605                                                                                                                                 |
| Name:                  | Number of subscribers of streaming project                                                                                          |
| Description:           | Identify the large subscribers of streaming project. Make sure that they will not break the streaming project.   |
|------------------------|------------------------------------------------------------------------------------------------------------------|
| Category:              | Configuration                                                                                                    |
| Unit:                  | count                                                                                                            |
| Thresholds / Severity: | Default threshold(s): 100000 ;1000000; 10000000 Severity level(s): 2; 3; 4                                       |
| User Action:           | Investigate whether these subscribers are created intentionally.                                                 |
| ID:                    | 606                                                                                                              |
| Name:                  | Row throughput of subscriber of streaming project                                                                |
| Description:           | Identify which subscriber of streaming project has low throughput measured in rows per second.                   |
| Category:              | Configuration                                                                                                    |
| Unit:                  | rows per sec                                                                                                     |
| Thresholds / Severity: | Default threshold(s): 1000 Severity level(s): 2                                                                  |
| User Action:           | Investigate why the subscriber works slowly.                                                                     |
| ID:                    | 607                                                                                                              |
| Name:                  | Transaction throughput of subscriber of streaming project                                                        |
| Description:           | Identify which subscriber of streaming project has transaction throughput measured in transactions per second.   |
| Category:              | Configuration                                                                                                    |
| Unit:                  | transactions per sec                                                                                             |
| Thresholds / Severity: | Default threshold(s): 1000 Severity level(s): 2                                                                  |
| User Action:           | Investigate why the subscriber works slowly.                                                                     |
| ID:                    | 608                                                                                                              |
| Name:                  | Row throughput of publisher of streaming project                                                                 |
| Description:           | Identify which publisher of streaming project has low throughput measured in rows per second.                 |
|------------------------|---------------------------------------------------------------------------------------------------------------|
| Category:              | Configuration                                                                                                 |
| Unit:                  | rows per sec                                                                                                  |
| Thresholds / Severity: | Default threshold(s): 1000 Severity level(s): 2                                                               |
| User Action:           | Investigate why the publisher works slowly.                                                                   |
| ID:                    | 609                                                                                                           |
| Name:                  | Transaction throughput of publisher of streaming project                                                      |
| Description:           | Identify which publisher of streaming project has transaction throughput measured in transactions per second. |
| Category:              | Configuration                                                                                                 |
| Unit:                  | transactions per sec                                                                                          |
| Thresholds / Severity: | Default threshold(s): 1000 Severity level(s): 2                                                               |
| User Action:           | Investigate why the publisher works slowly.                                                                   |
| ID:                    | 610                                                                                                           |
| Name:                  | Bad rows of project managed adapter                                                                           |
| Description:           | Identify which project managed adapter has much rows with error.                                              |
| Category:              | Configuration                                                                                                 |
| Unit:                  | row                                                                                                           |
| Thresholds / Severity: | Default threshold(s): 100 Severity level(s): 2                                                                |
| User Action:           | Investigate why the adapter has such much rows with error.                                                    |
| ID:                    | 611                                                                                                           |
| Name:                  | High latency of project managed adapter                                                                       |
| Description:           | Identify which project managed adapter has high latency.                                                      |
| Category:              | Configuration                                               |
|------------------------|-------------------------------------------------------------|
| Unit:                  | microsecond                                                 |
| Thresholds / Severity: | Default threshold(s): 1000000 Severity level(s): 2          |
| User Action:           | Investigate why the adapter has high latency.               |
| ID:                    | 612                                                         |
| Name:                  | Large queue of stream of streaming project                  |
| Description:           | Identify which stream of streaming project has large queue. |
| Category:              | Configuration                                               |
| Thresholds / Severity: | Default threshold(s): 1000 Severity level(s): 2             |
| User Action:           | Investigate why the stream has large queue.                 |
| ID:                    | 613                                                         |
| Name:                  | Large store of stream of streaming project                  |
| Description:           | Identify which stream of streaming project has large store. |
| Category:              | Configuration                                               |
| Unit:                  | row                                                         |
| Thresholds / Severity: | Default threshold(s): 10000 Severity level(s): 2            |
| User Action:           | Investigate why the stream has large store.                 |
| ID:                    | 700                                                         |
| Name:                  | Agent availability                                          |
| Description:           | Determines how many minutes the agent has been inactive.    |
| Category:              | Availability                                                |
| Unit:                  | minutes                                                     |
| Thresholds / Severity:   | Default threshold(s): 2; 4; 5 Severity level(s): 2; 3; 4                                                                                                                                               |
|--------------------------|--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| User Action:             | Investigate connection of agent and check if agent is up and running.                                                                                                                                  |
| ID:                      | 701                                                                                                                                                                                                    |
| Name:                    | Agent memory usage                                                                                                                                                                                     |
| Description:             | Determines what percentage of total memory available to agent is used.                                                                                                                                 |
| Category:                | Memory                                                                                                                                                                                                 |
| Unit:                    | percent                                                                                                                                                                                                |
| Thresholds / Severity:   | Default threshold(s): 80; 90; 95 Severity level(s): 2; 3; 4                                                                                                                                            |
| User Action:             | Investigate which adapter or processes use a lot of memory.                                                                                                                                            |
| ID:                      | 710                                                                                                                                                                                                    |
| Name:                    | Remote Subscription exception                                                                                                                                                                          |
| Description:             | Checks for recent exceptions in remote subscriptions and remote sources.                                                                                                                               |
| Category:                | Availability                                                                                                                                                                                           |
| User Action:             | Investigate the error message and the error code and restart the remote subscription if necessary.                                                                                                     |
| ID:                      | 711                                                                                                                                                                                                    |
| Name:                    | Remote subscription queued time                                                                                                                                                                        |
| Description:             | Check for how long the remote subscriptions have been in a queued state.                                                                                                                               |
| Category:                | Availability                                                                                                                                                                                           |
| Unit:                    | hours                                                                                                                                                                                                  |
| Thresholds / Severity:   | Default threshold(s): 24; 48; 72 Severity level(s): 2; 3; 4                                                                                                                                            |
| User Action:             | Investigate Data Provisioning Agent and Data Provisioning Server logs to check for errors, whether distribute command was executed and whether begin and end markers have been sent back by the Agent. |
| ID:                    | 712                                                                                                                                                                                                                                                                                 |
|------------------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Name:                  | Remote source not receiving change data                                                                                                                                                                                                                                             |
| Description:           | Check how long since Data Provisioning server last received change data from source database.                                                                                                                                                                                       |
| Category:              | Availability                                                                                                                                                                                                                                                                        |
| Unit:                  | hours                                                                                                                                                                                                                                                                               |
| Thresholds / Severity: | Default threshold(s): 24; 48; 72 Severity level(s): 2; 3; 4                                                                                                                                                                                                                         |
| User Action:           | Check if there are any errors reported for this remote source in REMOTE_SUBSCRIP- TION_EXCEPTIONS table and if there is change data for the subscribed tables in the source database that should have been replicated. Use START LATENCY MONITORING to monitor replication latency. |
| ID:                    | 713                                                                                                                                                                                                                                                                                 |
| Name:                  | Remote source applier delayed time                                                                                                                                                                                                                                                  |
| Description:           | A remote source has a delay in applying changes to the data. The time value calculation is derived from timestamp values in the view m_remote_source_statistics: the difference between the last received timestamp and the last applied timestamp.                                 |
| Category:              | Smart data integration                                                                                                                                                                                                                                                              |
| Thresholds / Severity: | Default threshold(s): 4 hours; 8 hours; 12 hours Severity level(s): 2; 3; 4                                                                                                                                                                                                         |
| User Action:           | Indicates a potential performance issue while applying change data.                                                                                                                                                                                                                 |
| Further information:   | SAP Note: 3159071 Check for SDI Applier Delay too long                                                                                                                                                                                                                              |
| ID:                    | 990                                                                                                                                                                                                                                                                                 |
| Name:                  | System Replication support issue in ESS                                                                                                                                                                                                                                             |
| Description:           | Identifies issues while initializing System Replication support in the Embedded Statistics Server (ESS).                                                                                                                                                                            |
| Category:              | Availability                                                                                                                                                                                                                                                                        |
| User Action:           | System replication support has been deactivated in ESS. Check the trace files for issues with System Replication.                                                                                                                                                                   |