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