Best Practice 1.3 – Implement
application and database monitoring for SAP
Set up your application and database monitoring to provide information about its internal state, status, and achievement of business outcomes. Some examples include transaction response time, available work processes, queue depth, error and dump messages, stalled batch jobs, and transaction throughput. Use this information to determine when a corrective action is required.
Suggestion 1.3.1 - Implement monitoring for databases supporting SAP applications
Continually monitor your SAP databases and establish alerts for common problems that can affect SAP system availability and performance. Common monitoring items include the following:
-
Free space in data area
-
Free space in logging area
-
Excessive locking activity
-
Cache utilization rates
-
Average query response time
-
Required security patches and hot fixes
-
Top table sizes and growth
Base alerting thresholds on healthy patterns of historical productive usage of your system. Continually review and adjust your alarm thresholds to prevent problems and to react to workload changes or growth.
For details on how to enable monitoring for your specific database, see your database software provider installation and operational guides.
Consider Amazon CloudWatch Application Insights for SAP HANA databases to analyze metric patterns using historical data to detect anomalies, and continuously track errors and exceptions from HANA, operating system, and infrastructure logs.
Suggestion 1.3.2 - Use SAP transactions and tools to understand the SAP application
Configure your SAP applications to provide information about their internal state, status, and the achievement of business outcomes. Use this information to determine when a response is required. Common monitoring items include the following:
-
Availability of application (ASCS, PAS, AAS) and database services
-
Number of active and concurrent users
-
Availability of work processes for users
-
Response time of user transactions
-
Response time of batch and non-interactive transactions
-
Error messages and dumps
-
Failed jobs
-
Full and slow queues
Set up the SAP EarlyWatch Alert reporting system in SAP Solution Manager to create regular reports on the status of your SAP systems. Regularly review and remediate issues found in these reports to prevent problems and avoid interruptions to workload service.
-
SAP Note: 2729186 - General Process of EWA Generation
[Requires SAP Portal Access] -
SAP Documentation: SAP Solution Manager 7.2 - Application Operations
-
SAP Lens [Performance efficiency]: Best Practice 16.1 – Have data to evaluate performance
Suggestion 1.3.3 - Implement monitoring for your data recovery and protection mechanisms
Implement monitoring for mechanisms that safeguard your SAP data in the case of a failure or disaster. Common monitoring items include:
-
Alerts for regular database backups, for example, to Amazon S3 with the AWS Backint Agent
-
Alerts for database replication, for example, HANA system replication failure or delays across Availability Zones
-
Alerts for file storage backups, for example, an EBS snapshot, an Amazon EFS backup, or an Amazon FSx backup
-
Alerts for recovery mechanisms which provide data resilience across Regions, for example, Amazon S3 buckets with cross-Region replication, Amazon S3 sync or CloudEndure Disaster Recovery
-
Alerts for any recovery mechanisms which provide data resilience across accounts, for example, Amazon S3 buckets with same-Region replication to a WORM S3 bucket or logging account
See the following links for further information:
Suggestion 1.3.4 - Expose SAP monitoring data outside of SAP tools for independent observability
SAP monitoring tools are limited to application and operating system level monitoring and do not cover the wide range of supporting services that give an end-to-end view of SAP service availability and health. Configure your SAP applications to provide metrics to a more holistic, external monitoring and visualization tool of your choice.
Use the metrics collected in the previous best practices and externalize these results such that you have an independent tool which can monitor, alert, and report on trends. An independent tool allows observability, root cause analysis, historical and trend reporting without being linked to the SAP system’s availability (that is, when SAP is in a disaster or fault mode).
-
SAP on AWS Blog: Serverless Monitoring for SAP NetWeaver
-
SAP on AWS Blog: Serverless Monitoring for SAP HANA
-
SAP on AWS Blog: Set up observability for SAP HANA databases with Amazon CloudWatch Application Insights
-
AWS Documentation: Create a CloudWatch Custom Metric
-
AWS Marketplace: Products and Tools for SAP Monitoring