On this page:

This page describes the procedure to enable metrics collection for the Native SAP HANA database using SNP CrystalBridge® Monitoring.

Create a Secondary Database Connection

SNP CrystalBridge® Monitoring runs on the SAP ABAP system, therefore it needs a secondary database connection to the Native HANA database to collect metrics.

To enable the connection to remote HANA database, maintain a secondary database connection by performing the following steps:

  1. Start the transaction SM30.
  2. Enter DBCON into Table/View field and click the Maintain button.
  3. Click New Entries.
  4. Enter a value in DB Connection field (e.g. NATIVE_HANA) and set DBMS to HDB.

  5. Enter a valid user name and DB password.

    The user must have administrator privileges for the monitoring to work correctly. Make sure that this DB user has at least the following authorization roles assigned: AFL_SYS_AFL_ERPA_EXECUTE, DBA_COCKPIT.

  6. Enter hostname and communication port in the Conn. info field as shown below:

  7. Click Save.

Add HANA Database to Monitoring Scope

To add a new HANA database for monitoring:

  1. Start the transaction /DVD/MON.
  2. Click Add system.
  3. From the Select main system type field, select HANA Database.
  4. Enter System name (e.g. HANA_DB) and description.

  5. Enter DB connection maintained in the previous section (e.g. HANA_NATIVE) and press Check DB connection to make sure that the DB connection works correctly.

  6. Press the OK button to add the system.

Start HANA Performance Collectors

To start monitoring the HANA database:

  1. Click Create collector job available in the Collector Jobs tab.
  2. Enter the System ID (e.g. HANA_DB) and select the Monitoring Profile APD_HDB1M.
  3. Click (Re)Start collector job.
  4. Repeat step1 to  step 3 for APD_HDB5M.

This schedules 2 periodic background jobs:

  • Collecting HANA metrics from 1 minute profile.
  • Collecting HANA metrics from 5 minute profile.