This is in continuation of my previous Article Monitoring of SAP Systems Using Azure Monitors – Part II

6. WORKBOOKS

Workbooks provide a flexible canvas for data analysis and the creation of rich visual reports within the Azure portal. They allow you to tap into multiple data sources from across Azure and combine them into unified interactive experiences.

6.1 SAP HANA

For checking the Workbook for SAP HANA, we can select SAP HANA under the Monitoring TAB and then select the Monitored SAP HANA instances which we need to display

This will first display the Overview of the SAP HANA Instances in which we can see an overview for Highest CPU and Memory touched so far

We can also see further details to the CPU, Memory, Disk and Network in and out along with the services running on the HANA Server

We can see detailed CPU utilization timeline under the Utilization Tab

In same tab we can have the detailed CPU utilization with MAX touched so far

On selecting the Memory button, we can see the Memory timeline for the Server.

In the same tab, we can see the detailed utilization of the Memory on HANA and MAX touched so far

In Backup tab, we can see all the successful backups of Database as well as Log area.

In same tab, we can see the Backup size and duration in a graphical view to check the trend of the backups

Going forward in same tab we can also see more detailing about each backup happened for the Hana

Under Replication Tab, we can also see the graph contains the details about replication tier for HANA Database

In same tab we can see further statistics of the replication of SYSTEMDB as well as its associated tenants

6.2 Linux Operating System

For checking the Workbook of Linux Operating System, we can select the OS(Linux) under the Monitoring Tab

In the same tab we can see the Average CPU Usage per mode in graphical view

Go further to the same tab we can also see overview Average Memory Usage, file system occupied space and Network in and out of the VM

In CPU Tab, we can see the details about CPU usage and timeline.

In the same tab we can see the Process and Forks details with count

In Memory Tab, we can see the Memory timeline usage and distribution

In same tab we can see the usage and timeline for the SWAP which is getting used

Going further in the same tab, we can see the details about the page and swap rate

In disk tab, we can see the mount points and respective details

In the same tab, we can see Read/Write Bytes and time along with the Output I/O

In Network Tab, we can see the inbound/outbound traffic, Network Packets and Network Bytes transferred

6.3 SAP NetWeaver

To check the workbook of SAP NetWeaver, we need to go to SAP NetWeaver Blade under Monitoring Tab

Under Overview tab we can find the availability graph of the system. We can also group the same by SID

We can also group the availability by application server

In Queue Statistics tab we can see the details about the dispatcher queues

6.4 High-Availability Pacemaker Cluster

To see the Workbook for HA Pacemaker Cluster, we need to go to the High-Availability Cluster(pacemaker) cluster blade under the Monitoring tab

In this we can see the cluster availability status in a graphical view

In the same tab, we can see the Node status and Resource Status which is attached to the Pacemaker Cluster

Going further to the same tab we can see the status of the primary node over time and resources under the primary node

Same way, we can see the status of the secondary node over time and resources attached to the Secondary node

6.5 Microsoft SQL Server

To see the Workbook of Microsoft SQL Server, we need to go to the Microsoft SQL Server blade under tab Monitoring

We can see the Batch request per sec, Compilations and Re-Compilations per second, CPU Usage and Latencies of the Microsoft SQL Server

In the same tab we can also see the hit ration and page life in a graphical view

Under Statistics Tab, we can see Memory overview as well as top 10 waits statistics

We can also see the top 10 SQL Statements and Top 12 Largest Tables in the SQL Server

Under Backup Tab, we can see the backup duration and sizes in the graphical view

This is end of Part – III, in next part Monitoring of SAP Systems Using Azure Monitors – Part IV of this article you can find more information about Alerts, Notifications and Troubleshooting Logs for Azure Monitors for SAP Solutions.