This blog will focus on monitoring on BW systems.
Monitoring productive BW systems
BW systems are at the often used as reporting systems within an SAP landscape.
When monitoring a productive system, you will need to finetune the monitoring templates for:
- ABAP 7.10 and higher Application template, for the ABAP application
- ABAP 7.10 and higher Technical instance template, for the ABAP application servers
- System host template
- Database template
ABAP application template
Make sure you cover in the ABAP application template the following items:
Availability:
- Message server HTTP logon
- System logon check
- RFC logon check
- License status
- Certificates expiry
- Update status
Performance and system health:
- Critical number ranges
- SICK detection
- Dumps last hour
- Cancelled jobs last hour
- Long running work processes and jobs (see blog): this is more tricky in a BW system, since it can have longer running extraction and processing jobs
Security:
- Global changeability should be that the system is closed
- Locking of critical users like SAP* and DDIC (see blog)
Fine tune the metrics so you are alerted on situation where the system is having issues.
ABAP application server template
Make sure you cover in the ABAP application server template the following items:
Availability:
- Local RFC logon test
- Local HTTP logon test (if any BW web scenario is used)
- Local Logon test
- Message server disconnects (see blog)
Application server performance and health:
- Amount of critical SM21 messages
- No more free work processes (see blog)
- Update response times
You can consider to setup extra custom metrics for the application servers:
- Checking for specific logon group to be active and working
- Detecting missing hardware ID
- Detecting OS signal
- Detecting PRIV modes
- Detecting resource exhaustion
- Detecting specific ABAP short dumps
For a BW system some numbers are typically higher than on an ECC or S4HANA system. Response times of 1.5 seconds would indicate horrible performance on ECC, but are normal on BW system.
System host template
For system host the regular CPU, memory, disc template is sufficient. Finetune the thresholds to your comfort level.
Database template
Important items of the database template:
- Database availability
- Database health checks
- Backup
Functions monitoring
Next to the availability and performance mentioned above, check also for monitoring certain functions: