SAP Hana Alert and Resolution

by sapposts · Published November 3, 2020 · Updated November 3, 2020

SAP Hana Alert and User action Please find below table for Hana alert and user action. Please find respective Hana Alert Description and User Action below:

Your can use search functionality.

Alert ID

Alert Name

Description

User Action

Internal statistics server problem

Identifies internal statistics server problem.

Resolve the problem. For more information, see the trace files. You may need to activate tracing first.

Host physical memory usage

Determines what percentage of total physical memory available on the host is used. All processes consuming memory are considered, including non-SAP HANA processes.

Investigate memory usage of processes.

Disk usage

Determines what percentage of each disk containing data, log, and trace files is used. This includes space used by non-SAP HANA files.

Investigate disk usage of processes. Increase disk space, for example by shrinking volumes, deleting diagnosis files, or adding additional storage.

Inactive services

Identifies inactive services.

Investigate why the service is inactive, for example, by checking the service's trace files.

Restarted services

Identifies services that have restarted since the last time the check was performed.

Investigate why the service had to restart or be restarted, for example, by checking the service's trace files.

Host CPU Usage

Determines the percentage CPU idle time on the host and therefore whether or not CPU resources are running low.

Investigate CPU usage.

Address space usage

Determines the address space consumption

Prepare to restart HANA.

Timer fallback

Notifies about the usage of the system timer fallback. The system timer is slower than native HANA timer.

Use HANA on a system configuration with Time Stamp Counter invariant set. See SAP Note 2753418.

Delta merge (mergedog) configuration

Determines whether or not the 'active' parameter in the 'mergedog' section of system configuration 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.

Change in SYSTEM layer the parameter active in section(s) mergedog to yes

Memory usage of name server

Determines what percentage of allocated shared memory is being used by the name server on a host.

Increase the shared memory size of the name server. In the 'topology' section of the nameserver.ini file, increase the value of the 'size' parameter.

Lock wait timeout configuration

Determines whether the 'lock_wait_timeout' parameter in the 'transaction' section of the indexserver.ini file is between 100,000 and 7,200,000.

In the 'transaction' section of the indexserver.ini file, set the 'lock_wait_timeout' parameter to a value between 100,000 and 7,200,000 for the System layer.

Record count of non-partitioned column-store tables

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

Consider partitioning the table only if you expect it to grow rapidly.

Table growth of non-partitioned column-store tables

Determines the growth rate of non-partitioned columns tables.

Consider partitioning the table.

Internal event

Identifies internal database events.

Resolve the event and then mark it as resolved by executing the SQL statement ALTER SYSTEM SET EVENT HANDLED ':' . Note that this is not necessary for INFO events.

Notification of all alerts

Determines whether or not there have been any alerts since the last check and if so, sends a summary e-mail to specified recipients.

Investigate the alerts.

Notification of medium and high priority alerts

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.

Investigate the alerts.

Notification of high priority alerts

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.

Investigate the alerts.

Open connections

Determines what percentage of the maximum number of permitted SQL connections are open. The maximum number of permitted connections is configured in the "session" section of the indexserver.ini file.

Investigate why the maximum number of permitted open connections is being approached.

Unassigned volumes

Identifies volumes that are not assigned a service.

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.

Record count of column-store table partitions

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.

Consider repartitioning the table.

Most recent savepoint operation

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.

Investigate why there was a delay defining the last savepoint and consider triggering the operation manually by executing the SQL statement ALTER SYSTEM SAVEPOINT.

Size of delta storage of column-store tables

Determines exceptionally large delta storages of column tables.

See SAP Knowledge Base Note 1977314. Investigate the delta merge history in the monitoring view M_DELTA_MERGE_STATISTICS. Consider merging the table delta manually.

Check internal disk full event

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.

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 ':' and ALTER SYSTEM SET EVENT HANDLED ':' .

License expiry

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.

Obtain a valid license and install it. For the exact expiration date, see the monitoring view M_LICENSE.

Log mode OVERWRITE

Determines whether or not the database is running in log mode "overwrite". Log mode "overwrite" does not support point-in-recovery (only recovery to a data backup) and is not recommended for productive systems.

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. When you change the log mode, you must restart the database system to activate the changes. It is also recommended that you perform a full data backup.

Unavailable volumes

Determines whether or not all volumes are available.

Investigate why the volume is not available.

Existence of data backup

Determines whether or not a data backup exists. Without a data backup, your database cannot be recovered.

Perform a data backup as soon as possible.

Status of most recent data backup

Determines whether or not the most recent data backup was successful.

Investigate why the last data backup failed, resolve the problem, and perform a new data backup as soon as possible.

Age of most recent data backup

Determines the age of the most recent successful data backup.

Perform a data backup as soon as possible.

Status of most recent log backups

Determines whether or not the most recent log backups for services and volumes were successful.

Investigate why the log backup failed and resolve the problem.

Long-running statements

Identifies long-running SQL statements.

Investigate the statement. For more information, see the table _SYS_STATISTICS.HOST_LONG_RUNNING_STATEMENTS.

Total memory usage of column-store tables

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)

Consider partitioning or repartitioning the table.

In-memory DataStore activation

Determines whether or not there is a problem with the activation of an in-memory DataStore object.

For more information, see the table _SYS_STATISTICS.GLOBAL_DEC_EXTRACTOR_STATUS and SAP Note 1665553.

Long running/idling cursors

Identifies long running/idling cursors. The threshold is based on M_INIFILE_CONTENTS.VALUE where KEY = "idle_cursor_lifetime".

Close the cursor in the application, or kill the connection by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION .For more information, see the table HOST_LONG_IDLE_CURSOR (_SYS_STATISTICS).

Memory usage of services

Determines what percentage of its effective allocation limit a service is using.

Check for services that consume a lot of memory.

Licensed memory usage

Determines what percentage of licensed memory is used.

Increase licensed amount of main memory. You can see the peak memory allocation since installation in the system view M_LICENSE (column PRODUCT_USAGE).

Memory usage of main storage of column-store tables

Determines what percentage of the effective allocation limit is being consumed by the main storage of individual column-store tables.

Consider partitioning or repartitioning the table.

RTEdump files

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.

Check the contents of the dump files.

Long-running serializable transactions

Identifies long-running serializable transactions.

Close the serializable transaction in the application or kill the connection by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION . For more information, see the table HOST_LONG_SERIALIZABLE_TRANSACTION (_SYS_STATISTICS).

Long-running uncommitted write transactions

Identifies long-running uncommitted write transactions.

Close the uncommitted transaction in the application or kill the connection by executing the SQL statement ALTER SYSTEM DISCONNECT SESSION . For more information, see the table HOST_UNCOMMITTED_WRITE_TRANSACTION (_SYS_STATISTICS).

Long-running blocking situations

Identifies long-running blocking situations.

Investigate the blocking and blocked transactions and if appropriate cancel one of them.

Number of diagnosis files

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

Investigate the diagnosis files.

Size of diagnosis files

Identifies large diagnosis files. Unusually large files can indicate a problem with the database.

Check the diagnosis files in the SAP HANA studio for details.

Crashdump files

Identifies new crashdump files that have been generated in the trace directory of the system.

Check the contents of the dump files.

Pagedump files

Identifies new pagedump files that have been generated in the trace directory of the system.

Check the contents of the dump files.

Savepoint duration

Identifies long-running savepoint operations.

Check disk I/O performance.

Columnstore unloads

Determines how many columns in columnstore tables have been unloaded from memory. This can indicate performance issues.

Check sizing with respect to data distribution.

Python trace activity

Determines whether or not the python trace is active and for how long. The python trace affects system performance.

If no longer required, deactivate the python trace in the relevant configuration file.

Instance secure store file system (SSFS) inaccessible

Determines if the instance secure store in the file system (SSFS) of your SAP HANA system is accessible to the database.

Check and make sure that the instance SSFS is accessible to the database.

Plan cache size

Determines whether or not the plan cache is too small.

Currently Alert 58 is inactive and replaced by Alert 91. Please activate Alert 91 - Plan Cache Hit Ratio

Percentage of transactions blocked

Determines the percentage of transactions that are blocked.

Investigate blocking and blocked transactions and if appropriate cancel some of them.

Sync/Async read ratio

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 HANA I/O performance in certain scenarios.

Please refer to SAP note 1930979.

Sync/Async write ratio

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 HANA I/O performance in certain scenarios.

Please refer to SAP note 1930979.

Expiration of database user passwords

Identifies database users whose password is due to expire in line with the configured password 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 DISABLE PASSWORD LIFETIME).

Change the password of the database user.

Granting of SAP_INTERNAL_HANA_SUPPORT role

Determines if the internal support role (SAP_INTERNAL_HANA_SUPPORT) is currently granted to any database users.

Check if the corresponding users still need the role. If not, revoke the role from them.

Total memory usage of table-based audit log

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.

Consider exporting the content of the table and then truncating the table.

Runtime of the log backups currently running

Determines whether or not the most recent log backup terminates in the given time.

Investigate why the log backup runs for too long, and resolve the issue.

Storage snapshot is prepared

Determines whether or not the period, during which the database is prepared for a storage snapshot, exceeds a given threshold.

Investigate why the storage snapshot was not confirmed or abandoned, and resolve the issue.

Table growth of rowstore tables

Determines the growth rate of rowstore tables

Try to reduce the size of row store table by removing unused data

Total memory usage of row store

Determines the current memory size of a row store used by a service

Investigate memory usage by row store tables and consider cleanup of unused data

Enablement of automatic log backup

Determines whether automatic log backup is enabled.

Enable automatic log backup. For more details please see SAP HANA Administration Guide.

Consistency of internal system components after system upgrade

Verifies the consistency of schemas and tables in internal system components (for example, the repository) after a system upgrade.

Contact SAP support.

Row store fragmentation

Check for fragmentation of row store.

Implement SAP Note 1813245.

Number of log segments

Determines the number of log segments in the log volume of each serviceCheck for number of log segments.

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.

Overflow of rowstore version space

Determines the overflow ratio of the rowstore version space.

This alert is deprecated. Please refer to alert 75 "Rowstore version space skew" for indication of rowstore version accumulation

Overflow of metadata version space

Determines the overflow ratio of the metadata version space.

This alert is deprecated. Please refer to alert 75 "Rowstore version space skew" for indication of rowstore version accumulation

Rowstore version space skew

Determines whether the rowstore version chain is too long.

Identify the connection or transaction that is blocking version garbage collection. You can do this in the SAP HANA studio 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 information, you can find table information by using query "SELECT * FROM TABLES WHERE TABLE_OID = ".

76	Discrepancy between host server times	Identifies discrepancies between the server times of hosts in a scale-out system.	Check operating system time settings.
77	Database disk usage	Determines the total used disk space of the database. All data, logs, traces and backups are considered.	Investigate the disk usage of the database. See system view M_DISK_USAGE for more details.
78	Connection between systems in system replication setup	Identifies closed connections between the primary system and a secondary system. If connections are closed, the primary system is no longer being replicated.	Investigate why connections are closed (for example, network problem) and resolve the issue.
79	Configuration consistency of systems in system replication setup	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.	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].
80	Availability of table replication	Monitors error messages related to table replication.	Determine which tables encountered the table replication error using system view M_TABLE_REPLICAS, and then check the corresponding indexserver alert traces.
81	Cached view size	Determines how much memory is occupied by cached view	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.
82	Timezone conversion	Compares SAP HANA internal timezone conversion with Operating System timezone conversion.	Update SAP HANA internal timezone tables (refer to SAP note 1932132).
83	Table consistency	Identifies the number of errors and affected tables detected by _SYS_STATISTICS.Collector_Global_Table_Consistency.	Contact SAP support.
84	Insecure instance SSFS encryption configuration	Determines whether the master key of the instance secure store in the file system (SSFS) of your SAP HANA system has been changed. If the SSFS master key is not changed after installation, it cannot be guaranteed that the initial key is unique.	Change the instance SSFS master key as soon as possible. For more information, see the SAP HANA Administration Guide.
85	Insecure systemPKI SSFS encryption configuration	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.	Change the system PKI SSFS master key as soon as possible. For more information, see the SAP HANA Administration Guide.
86	Internal communication is configured too openly	Determines whether the ports used by SAP HANA for 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 multiple-host systems, internal communication channels are externally exploitable.	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 HANA Master Guide.
87	Granting of SAP HANA DI support privileges	Determines if support privileges for the SAP HANA Deployment Infrastructure (DI) are currently granted to any database users or roles.	Check if the corresponding users still need the privileges. If not, revoke the privileges from them.
88	Auto merge for column-store tables	Determines if the delta merge of a table was executed successfully or not.	The delta merge was not executed successfully for a table. Check the error description in view M_DELTA_MERGE_STATISTICS and also Indexserver trace.
89	Missing volume files	Determines if there is any volume file missing.	Volume file missing, database instance is broken, stop immediately all operations on this instance.
91	Plan cache hit ratio	Determines whether or not the plan cache hit ratio is too low.	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.
92	Root keys of persistent services are not properly synchronized	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.	Trigger a savepoint for this service or flush the SSFS cache using hdbcons
93	Streaming License expiry	Determines how many days until your streaming license expires. Once your license expires, you can no longer start streaming projects.	Obtain a valid license and install it. For the exact expiration date, see the monitoring view M_LICENSES.
94	Log replay backlog for system replication secondary	System Replication secondary site has a higher log replay backlog than expected.	Investigate on secondary site, why log replay backlog is increased
95	Availability of Data Quality reference data (directory files)	Determine the Data Quality reference data expiration dates.	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 HANA Smart Data Integration and SAP HANA Smart Data Quality.)
96	Long-running tasks	Identifies all long-running tasks.	Investigate the long-running tasks. For more information, see the task statistics tables or views in _SYS_TASK schema and trace log.
97	Granting of SAP HANA DI container import privileges	Determines if the container import feature of the SAP HANA Deployment Infrastructure (DI) is enabled and if import privileges for SAP HANA DI containers are currently granted to any database users or roles.	Check if the identified users still need the privileges. If not, revoke the privileges from them and disable the SAP HANA DI container import feature.
98	LOB garbage collection activity	Determines whether or not the lob garbage collection is activated.	Activate the LOB garbage collection using the corresponding configuration parameters.
99	HANA version	Checks the installed HANA version.	Please check if your SAP HANA system can be upgraded to a newer version.
101	SQL access for SAP HANA DI technical users	Determines if SQL access has been enabled for any SAP HANA DI technical users. SAP HANA DI technical users are either users whose names start with '_SYS_DI' or SAP HANA DI container technical users (, #DI, #OO).	Check if the identified users ('_SYS_DI*' users or SAP HANA DI container technical users) still need SQL access. If not, disable SQL access for these users and deactivate the users.
102	Existence of system database backup	Determines whether or not a system database backup exists. Without a system database backup, your system cannot be recovered.	Perform a backup of the system database as soon as possible.
103	Usage of deprecated features	Determines if any deprecated features were used in the last interval.	Check the view M_FEATURE_USAGE to see which features were used. Refer to SAP Note 2425002 for further information.
104	Log shipping backlog for system replication secondary	System Replication secondary site has a higher log shipping backlog than expected.	Investigate on primary and secondary site, why log shipping backlog is increased
105	Total Open Transactions Check	The check monitors the number of open transactions per service	Double check if the application is closing the connection correctly, and whether the high transaction load on the system is expected.
106	ASYNC replication in-memory buffer overflow	Checks if local in-memory buffer in ASYNC replication mode runs full	Check buffer size, peak loads, network, IO on secondary
109	Backup history broken	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.	Perform a data backup as soon as possible to ensure that the service is fully recoverable.
110	Catalog Consistency	Identifies the number of errors and affected objects detected by _SYS_STATISTICS.Collector_Global_Catalog_Consistency.	Contact SAP support.
111	Replication status of Replication Log	Check whether the status of replication log is disabled.	Truncate replication log table and enable replication log.
113	Host open file count	Determines what percentage of total open file handles are in use. All processes are considered, including non-SAP HANA processes. Compare M_HOST_RESOURCE_UTILIZATION.OPEN_FILE_COUNT with M_HOST_INFORMATION.VALUE of M_HOST_INFORMATION.KEY open_file_limit.	This is normal behavior and neither a SAP HANA nor 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
114	Host active async io count	Determines what percentage of total asynchronous input/output requests are in use. All processes are considered, including non-SAP HANA processes. Compare M_HOST_RESOURCE_UTILIZATION.ACTIVE_ASYNC_IO_COUNT with M_HOST_INFORMATION.VALUE of M_HOST_INFORMATION.KEY async_io_limit.	See SAP Notes 1868829.
115	Timezone environment variable verification	Determines if the timezone environment variable TZ can be interpreted. See M_TIMEZONE_ALERTS. Otherwise HANA falls back to a system call which can cause significant performance issues.	Please set the timezone environment variable TZ to a valid value according to the POSIX documentation and restart the HANA database. See also SAP Note 2100040.
117	Record count of non-partitioned column-store tables (include)	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 considered if tables are expected to grow rapidly (a non-partitioned table cannot contain more than 2,147,483,648 (2 billion) rows).	Consider partitioning the table only if you expect it to grow rapidly.
127	Record count of column-store table partitions (include)	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.	Consider repartitioning the table.
128	LDAP Enabled Users without SSL	Checks if any user is enabled for LDAP Authentication and SSL is off.	Configure SSL to reduce risk of man-in-the-middle attacks and privacy protection.
129	Check trusted certificate expiration date	Determines if there are any trusted certificates that will expire soon or have already expired.	Replace the certificates.
130	Check own certificate expiration date	Determines if there are any own or chain certificates that will expire soon or have already expired.	Replace the certificates.
131	Session requests queued by admission control	Determines the number of session requests waiting in the admission control queue. This can indicate an issue with the response time of the request.	Investigate why the session requests newly queued by admission control. Refer to M_ADMISSION_CONTROL_EVENTS for more information.
132	Session requests rejected by admission control	Determines the number of session requests newly rejected by admission control. This can indicate an issue with the availability of the database.	Investigate why the session requests newly rejected by admission control. Refer to M_ADMISSION_CONTROL_EVENTS for more information.
133	Check out-of-buffers event for a buffer cache	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.	Resolve the out-of-buffers event by increasing the max_size parameter of the affected buffer cache.
134	Administration of SAP HANA DI user groups by user administrators	Determines if any SAP HANA DI user groups can be managed by a user with the USER ADMIN system privilege. SAP HANA DI user groups are user groups whose names start with '_SYS_DI#'.	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 DISABLE USER ADMIN).
136	Unsupported configuration parameter values	Checks if configuration parameters are set to unsupported values	Check if system is running in a supported state
137	Restart required after configuration change	Checks if services require a restart after a configuration was changed	Restart services (see M_CONFIGURATION_PARAMETER_VALUES) to allow the changed configuration to become active.
500	Dbspace usage	Checks for the dbspace size usage.	Investigate the usage of dbspace and increase the size.
501	Dbspace status	Determines whether or not all dbspaces are available.	Investigate why the dbspace is not available.
502	Dbspace file status	Determines whether or not all dbspace files are available.	Investigate why the dbspace file is not available.
504	DT Version mismatch	Checks that dynamic tiering and SAP HANA versions match.	Check the reason for the mismatch, and correct the problem. See SAP Note 2637835.
505	ES backup history broken	If the backup history is broken, the service is not fully recoverable via backup.	Perform a data backup as soon as possible to ensure that the service is fully recoverable.
600	Inactive Streaming applications	Identifies inactive Streaming applications.	Investigate why the Streaming application is inactive, for example, by checking the Streaming application's trace files.
601	Inactive Streaming project managed adapters	Identifies inactive Streaming project managed adapters.	Investigate why the Streaming project managed adapter is inactive, for example, by checking the trace files.
602	Streaming project physical memory usage	Determines what percentage of total physical memory available on the host is used for the streaming project.	Investigate memory usage of the streaming project.
603	Streaming project CPU usage	Determines the percentage CPU usage for a streaming project on the host and therefore whether or not CPU resources are running out.	Investigate CPU usage.
604	Number of publishers of streaming project	Identify the large publishers of streaming project. Make sure that they will not break the streaming project.	Investigate whether these publishers are created intentionally.
605	Number of subscribers of streaming project	Identify the large subscribers of streaming project. Make sure that they will not break the streaming project.	Investigate whether these subscribers are created intentionally.
606	Row throughput of subscriber of streaming project	Identify which subscriber of streaming project has low throughput measured in rows per second.	Investigate why the subscriber works slowly.
607	Transaction throughput of subscriber of streaming project	Identify which subscriber of streaming project has transaction throughput measured in transactions per second.	Investigate why the subscriber works slowly.
608	Row throughput of publisher of streaming project	Identify which publisher of streaming project has low throughput measured in rows per second.	Investigate why the publisher works slowly.
609	Transaction throughput of publisher of streaming project	Identify which publisher of streaming project has transaction throughput measured in transactions per second.	Investigate why the publisher works slowly.
610	Bad rows of project managed adapter	Identify which project managed adapter has much rows with error.	Investigate why the adapter has such much rows with error.
611	High latency of project managed adapter	Identify which project managed adapter has high latency.	Investigate why the adapter has high latency.
612	Large queue of stream of streaming project	Identify which stream of streaming project has large queue.	Investigate why the stream has large queue.
613	Large store of stream of streaming project	Identify which stream of streaming project has large store.	Investigate why the stream has large store.
700	Agent availability	Determines how many minutes the agent has been inactive.	Investigate connection of agent and check if agent is up and running.
701	Agent memory usage	Determines what percentage of total memory available to agent is used.	Investigate which adapter or processes use a lot of memory.
710	Remote Subscription exception	Checks for recent exceptions in remote subscriptions and remote sources.	Investigate the error message and the error code and restart the remote subscription if necessary.

SAP Hana Alert and Resolution

Related

You may also like...

Leave a Reply Cancel reply

SAP Hana Alert and Resolution

Related

You may also like...

SAP HANA Platform for Real-Time Applications and Analytics

SAP HANA Tutorial – SAP HANA Training: What is SAP HANA ?

SAP on Oracle: FAQ. Questions and Answers

Leave a Reply Cancel reply