SAP HANA System Monitoring

Configure SAP HANA System for Monitoring

1. Navigate to Dashboards → Administrator.

Note:

  • The port will default to 3<System Number>15, override it if different, such as in a Multi-tenant Database Container.

  • For the "Tenant Database" field, please provide the HANA Tenant SID of the HANA Database.

  • If the HANA Database is to be connected as SYSTEMDB, enter "SYSTEMDB" in the Tenant Database field.

4. A pop-up message will confirm that the SAP HANA DB has been successfully added. Click OK to dismiss and configure the SAP HANA user account for monitoring.

Note: Please take note of the SAP HANA Authorization requirements.

6. A pop-up message will confirm that the HANA account has been created successfully. Click OK to complete the process.

7. The newly added system will appear in the "SAP HANA System" panel.

8. The system will show up in the service grid within 5-15 minutes.

IT-Conductor SAP HANA Authorizations Requirements

For each HANA database, including the SYSTEMDB that will be monitored, create a monitoring user with the following SQL:

create user <Monitoring user> <Monitoring User Password> no force_first_password_change;
alter user <Monitoring user> DISABLE PASSWORD LIFETIME;
grant MONITORING to <Monitoring user>

Note:

  • Option "no force_first_password_change" - the password does not need to be changed on the first time login.

  • Option "DISABLE PASSWORD LIFETIME" is considered a technical user. Thus, it is exempted from changing the password as specified in the parameter "maximum_password_lifetime".

ALTER USER <user> DISABLE PASSWORD LIFETIME

To verify it has a lifetime password:

SELECT USER_NAME, PASSWORD_CHANGE_TIME FROM USERS WHERE USER_NAME = '<user>';

It should have an empty "PASSWORD_CHANGE_TIME" value.

Monitoring Role (extract from Security Guide) - This role contains privileges for full read-only access to all metadata, the current system status in the system monitoring views, and the data collected by the statistics server.

Note: For MDC (multi-tenant), the user should be created in the SYSTEMDB, and each tenant database will be registered in IT-Conductor.

To list (SQL) port numbers for SYSTEMDB and Tenant DBs used in registering.

 select * from sys_databases.m_services
 where sql_port <> 0;

Last updated