This is in continuation of my previous Article Monitoring of SAP Systems Using Azure Monitors – Part II
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.
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
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
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
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
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.
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.
- SAP Managed Tags:
1 Comment
