Come join our live training webinar every other Wednesday at 11am PST and hear LogicMonitor experts explain best practices and answer common questions. We understand these are uncertain times, and we are here to help!
LogicMonitor’s SAP HANA monitoring package leverages the SAP JDBC package to monitor and alert on the status of the HANA database in SAP systems.
Logicmonitor’s SAP HANA package has been developed with version 2.0 of SAP HANA on-premise server and version 4.0 of the SAP HANA cloud. It may work on older versions. Installations of SAP using databases other than HANA are not supported by this package.
As SAP releases newer versions of HANA, LogicMonitor will test and extend coverage as necessary.
Follow these steps to set up monitoring for HANA databases in SAP systems.
LogicMonitor uses the SAP JDBC connector to get data from SAP HANA. The SAP JDBC is .jar file that must be installed on the Collector.
Add your SAP HANA resources into monitoring if they have not yet been added. For more information on adding resources into monitoring, see Adding Devices.
Logicmonitor needs an SAP HANA user and password to access data. This user needs “read only” access to some specific system tables. Use the SAP SQL console to create a user and give the user access to the tables/views.
Use the following configuration as a guide for creating a user and setting permissions. Your SAP installation may require a different configuration.
CREATE RESTRICTED USER LM2_USER PASSWORD "Enter Your Password" NO FORCE_FIRST_PASSWORD_CHANGE; ALTER USER LM_USER ENABLE CLIENT CONNECT; GRANT CATALOG READ TO LM_USER; GRANT SELECT ON _SYS_STATISTICS.STATISTICS_CURRENT_ALERTS TO LM_USER; GRANT SELECT ON SYS.M_BACKUP_CATALOG TO LM_USER; GRANT SELECT ON SYS.M_BLOCKED_TRANSACTIONS TO LM_USER; GRANT SELECT ON SYS.M_CACHES TO LM_USER; GRANT SELECT ON SYS.M_CONNECTION_STATISTICS TO LM_USER; GRANT SELECT ON SYS.M_CONNECTIONS TO LM_USER; GRANT SELECT ON SYS.M_DATABASE TO LM_USER; GRANT SELECT ON SYS.M_DATABASES TO LM_USER; GRANT SELECT ON SYS.M_DATABASE_HISTORY TO LM_USER; GRANT SELECT ON SYS.M_DISKS TO LM_USER; GRANT SELECT ON SYS.M_EXPENSIVE_STATEMENTS TO LM_USER; GRANT SELECT ON SYS.M_GARBAGE_COLLECTION_STATISTICS TO LM_USER; GRANT SELECT ON SYS.M_HOST_INFORMATION TO LM_USER; GRANT SELECT ON SYS.M_HOST_RESOURCE_UTILIZATION TO LM_USER; GRANT SELECT ON SYS.M_JOB_PROGRESS TO LM_USER; GRANT SELECT ON SYS.M_LANDSCAPE_HOST_CONFIGURATION TO LM_USER; GRANT SELECT ON SYS.M_LICENSE TO LM_USER; GRANT SELECT ON SYS.M_MEMORY TO LM_USER; GRANT SELECT ON SYS.M_RECORD_LOCKS TO LM_USER; GRANT SELECT ON SYS.M_SERVICE_MEMORY TO LM_USER; GRANT SELECT ON SYS.M_SERVICE_STATISTICS TO LM_USER; GRANT SELECT ON SYS.M_SERVICE_THREADS TO LM_USER; GRANT SELECT ON SYS.M_SERVICES TO LM_USER; GRANT SELECT ON SYS.M_SHARED_MEMORY TO LM_USER; GRANT SELECT ON SYS.M_SYSTEM_OVERVIEW TO LM_USER; GRANT SELECT ON SYS.M_TABLE_VIRTUAL_FILES TO LM_USER; GRANT SELECT ON SYS.M_TRANSACTIONS TO LM_USER; GRANT SELECT ON SYS.M_VOLUME_IO_STATISTICS TO LM_USER; GRANT SELECT ON SYS.M_VOLUME_SIZES TO LM_USER; GRANT SELECT ON SYS.M_VOLUMES TO LM_USER;
The following custom properties must be set on the SAP HANA resource within LogicMonitor. For more information on setting properties, see Resource and Instance Properties.
jdbc:sap//hostname:port
Import all the SAP HANA LogicModules from the LogicMonitor Public Repository. See LogicModules in Package.
If these LogicModules are already present, ensure you have the most recent versions. If all setup requirements are complete, data collection will start once the LogicModules are imported.
LogicMonitor’s package for SAP HANA consists of the following LogicModules. For full coverage, please ensure that all of these LogicModules are imported into your LogicMonitor platform.
When setting static datapoint thresholds on the various metrics tracked by this package’s DataSources, LogicMonitor follows the technology owner’s best practice KPI recommendations. If necessary, we encourage you to adjust these predefined thresholds to meet the unique needs of your environment. For more information on tuning datapoint thresholds, see Tuning Static Thresholds for Datapoints.
In This Article