Skip to main content

SAP HANA

Pre-requisites

Check the supported versions

DBmarlin supports versions of SAP HANA from 2.0 and above. Please check the list of supported platforms before continuing and contact us if you are not sure.

Create a monitoring user with the correct permissions

Before adding a target SAP HANA instance in the UI you should first create a dbmarlin user in the target database instance. Note you can choose to use a name other than dbmarlin if you prefer.

For SAP HANA you can create a monitoring user like this:

CREATE USER dbmarlin PASSWORD SecurePassword1 NO FORCE_FIRST_PASSWORD_CHANGE;
GRANT MONITORING TO dbmarlin;

Collecting SQL statement executions

In order to collect executions counts at the SQL statement level, plan_cache_statistics_enabled must be set to TRUE.

/* Enable plan_cache_statistics_enabled=true otherwise values will be 0 */
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'SYSTEM') SET ('sql', 'plan_cache_statistics_enabled') = 'TRUE' WITH RECONFIGURE;

/* Check if STATISTICS_COLLECTION_ENABLED=TRUE  */
SELECT * from M_SQL_PLAN_CACHE_OVERVIEW;

Adding the Database Target

This is done through the User Interface using the Add Database screen