Wednesday, 15 May 2024

SAP DataSphere – SAP HANA Database Monitoring

Login to SAP DataSphere and navigate to path System -> Configuration. Select the Menu option 'Database Access' -> Database Analysis Users.

SAP DataSphere – SAP HANA Database Monitoring

Select the option Create for new DB user.

SAP DataSphere – SAP HANA Database Monitoring

Provide the Name of the user along with No# of days the user will be active ( after which the user ID will get deleted) and click on 'Create'.

SAP DataSphere – SAP HANA Database Monitoring

HAND DB Analysis User will be created and access details will pop up in next screen. Please make not of User Name, Host, Port and Password.

SAP DataSphere – SAP HANA Database Monitoring

We can see the newly created user under 'Database Analysis Users' along with its status and Validity date.

SAP DataSphere – SAP HANA Database Monitoring

To Access the SAP HANA Cockpit, check the User Name and click on 'Open SAP HANA Cockpit'

SAP DataSphere – SAP HANA Database Monitoring

This will take us to new webpage/ tab for HANA DB Cockpit and prompt us to enter the Login details.

SAP DataSphere – SAP HANA Database Monitoring

After successful login we land on the Database Overview page of SAP DataSphere HANA DB.

SAP DataSphere – SAP HANA Database Monitoring

Here we have option to select different view from the drop down menu. 

SAP DataSphere – SAP HANA Database Monitoring

Select Monitoring the see the overall status of the SAP HANA DB. Now, we will explore some key monitoring artifacts like Storage, CPU, Threads, Transactions, etc.,.

SAP DataSphere – SAP HANA Database Monitoring

1. Storage Utilization will provide statistic of used disk space against total allocated space of the SAP DataSphere tenant.

SAP DataSphere – SAP HANA Database Monitoring

Analyze Workloads will provide details view of 'Top SQL Statements', 'Background Jobs', 'Timeline' & active  'Threads'.

SAP DataSphere – SAP HANA Database Monitoring

We also have option to select the time period and Filter the view.

SAP DataSphere – SAP HANA Database Monitoring

Background jobs will show the status of background job, which were schedule for the selected period.

SAP DataSphere – SAP HANA Database Monitoring

Under 'Timeline', we can monitor different application threads along with duration and status.

SAP DataSphere – SAP HANA Database Monitoring

In Menu option 'Threads', we can select the different monitoring option for the process threads and see the overall performance. Here I've selected option as 'Thread State', we can also select different option for more detailed view.

SAP DataSphere – SAP HANA Database Monitoring

It also has option to select 'Secondary Dimension' and monitor the statistics based on selected criteria.

SAP DataSphere – SAP HANA Database Monitoring

2. Manage Services, will show the overall status of core HANA DB services for the SAP DataSphere tenant.

SAP DataSphere – SAP HANA Database Monitoring

we can see the service status, Database SID and overall status. Below image shows HANA DB services are running with one high priority alert with in the 'indexserver'. We can also access 'indexserver' trace file by selecting option ' Go to Trace file'.

SAP DataSphere – SAP HANA Database Monitoring

3. Memory Usage: This menu option provide us high level view of Memory utilization.

SAP DataSphere – SAP HANA Database Monitoring

To access detailed information on memory utilization, click on option ' Monitoring Performance', This will show us detailed statistical view. we can see memory allocation to different DB components and services.

SAP DataSphere – SAP HANA Database Monitoring

with in the performance Monitor, we also have option to view performance metrics CPU & Memory as well.

SAP DataSphere – SAP HANA Database Monitoring

More detailed view of Memory usage with respect to Workloads, Buffer Cache and Paging can also be accessed by selecting the option for menu (...).

SAP DataSphere – SAP HANA Database Monitoring

4. Monitoring Table usage:  We can access table space usage statistics from 'Monitoring'

SAP DataSphere – SAP HANA Database Monitoring

we can monitor the tables and its space utilization and statistics with different spaces.

SAP DataSphere – SAP HANA Database Monitoring

5. Blocked Transactions: Performance of HANA DB get severely impacted if we have any blocked transaction at the DB level. 

SAP DataSphere – SAP HANA Database Monitoring

We can see the active transaction in blocked status, if any.

SAP DataSphere – SAP HANA Database Monitoring

6. CPU Usage: We can monitoring overview of CPU utilization and details view can be access with options like 'Monitoring Performance' and 'Analyze Workloads'.

SAP DataSphere – SAP HANA Database Monitoring

In case we observe any issue, which requires SAP attention than we need to open a support ticket with SAP to get the required help.

No comments:

Post a Comment