Monitoring SAP HANA with SAP Solution Manager
Monitoring with SAP Solution Manager
Architecture: Logical Landscape View
Landscape data is sent from technical systems to SLD (Solution Landscape Directory) and then to LMDB.
Diagnostics agent are installed on each host. These send monitoring data, logs and traces to SAP solution manager.
The goal is to monitor availability of services in the SAP HANA Database.
SOLMAN_WORKCENTER is a central SAP GUI transaction for configuration, set-up, administration and monitoring with the SAP Solution Manager.
The SAP Solution Manager Administration work center is embedded in the SAP Solution Manager work center framework.
The work center overview can be opened in different ways:
• By calling transaction SOLMAN_WORKCENTER in the SAP GUI
• By opening transaction SM_WORKCENTER or the following URL on the SAP Solution Manager http://<host>:<port>/sap/bc/webdynpro/ sap/ags_workcenter
• In the SAP Netweaver Business Client
• The SAP Solution Manager Administration work center can also be opened separately in a browser by calling the URL http://<host>:<port>/sap/bc/webdynpro/sap/ags_workcenter?WORKCENTER=AGS_WORK_SM_ADMIN
System Monitoring – Monitoring with SAP Solution Manager
With the System Monitoring you are able to monitor:
• Availability of SAP HANA Services
• Alert Status of SAP HANA internal alerting
• Host Level Monitoring
You will get SLT monitoring and DBA cockpit integration in latest versions only.
You can do SAP HANA system and monitoring configuration via SOLMAN_WORKCENTER transaction in SAP Solution Manager.
In SAP note 1747682, you will get the required documentation and patch levels for integration of SAP HANA with SAP solution manager.
There is also a master note 1652693 which needs to be applied using SAP Solution Manger -> Workcenter (SOLMAN_WORKCENTER transaction) -> SAP Solution Manager: Configuration -> System Preparation -> Implement SAP note
For integration, below need to be installed first:
- SAP Solution Manager
- SAP hostagent
Setup host agent and Diagnostics agent:
See sap note 1625203
Create user with monitoring role in SAP HANA studio
Register SAP HANA in SLD
See sap note 1018839
You need to ensure that the Lifecycle Management package is installed on the SAP HANA Server: Check if the directory lm_structure (SLD data supplier) is available in /usr/sap/<SID>. The SAP unified installer installs this package with standard SAP HANA installations.
Create a system in solution manager.
Enter HANA <SID>, instance number, host name, etc.
Once the system is added, click on Configure system
Most steps in the guided procedures for configuration will be performed semi-automatically, and traffic lights will indicate status.
If the SMDAgent was installed correctly, the Assign Diagnostic Agents step will automatically display the right Agent to be selected by the user.
The right introscope server name, monitoring user, SAP HANA hostname, etc. will also be displayed by default for the Enter System Parameters step. You may want to change the user, e.g. in case you assigned a new monitoring user.
You are now ready to start the technical monitoring of SAP HANA.
You can check the monitoring metrics with the Alerting Directory Browser.
Technical monitoring metrics up and running
From the technical monitoring -> system monitoring area, select SAP HANA system (pushbutton)
Click on system monitoring button -> Start embedded or start new window.
Display metrics e.g. check Availability.