The Core of SAP Basis Monitoring


Business person touching colorful charts and diagrams-1

How does a typical SAP customer deal with technical Basis operations? 

SAP operations is normally managed by:

  • in-house teams, or
  • outsourced to an application service provider (ASP), managed service provider (MSP) sometimes also referred to as application management services (AMS), or
  • a hybrid support model

SAP monitoring and incident management are big parts of SAP support and regardless who is responsible for it, needs to be performed.  Let's revisit the top areas which needs constant monitoring.  In the next few weeks, we'll share our experiences around the top SAP Basis Monitoring areas.  We will use this main page as an anchor to the various topics below, relisted from the blog BASIS or BASICS and will be added to as time goes on.  The first topic will be included in this post.

Monitoring Areas (in no particular order of importance)

  1. Database Lock waits & Deadlocks
  2. Spool Management
  3. Database Allocation & Utilization
  4. Backup / Restore Information
  5. Scheduled DB jobs
  6. DB Performance Analysis
  7. Application Server Resource Utilization: Processes, Dispatcher Queues
  8. Update Records
  9. tRFC & qRFC Queues
  10. System Logs (App, DB, OS)
  11. Background (Batch) Jobs
  12. Application Locks and Enqueue
  13. Users
  14. ABAP Dump Analysis
  15. Workload: Application Performance Analysis
  16. O/S Monitor
  17. Connectivity
  18. Security

Database Lock Waits & Deadlocks

Database Lockwaits and Deadlock SAP IT-Conductor
  • Long waits and deadlocks typically arise from bulk or batch operations with mass updates or deletes, while other jobs or online activities are also working on the same set of table data.

  • DB locking and wait mechanisms can vary by database, but the essential concept is to synchronize access to data and ensure consistency.  Application design has to consider both performance and data integrity in a parallel processing environment.

  • Let's use HANA as an example, please refer to 1999998 - FAQ: SAP HANA Lock Analysis for detailed background on the topic

  • Basis (DBA is implied) should care about two main types of situations:

    • Performance impacts of wait or blocked situations, bottlenecks and contention

    • Deadlocks: transactions can get rolled back when there is lock wait timeout, deadlock detection, or if the application is designed to not wait for busy resources

  • ABAP: TCODE DB01 "Blocked Transactions" is under the Diagnostics → Locks section of DBACOCKPIT, or Lock Monitor

  • HANA Studio → Performance → Blocked Transactions

  • Database MiniChecks → Locks → (Internal or Transactional) scripts to check for various lock situations

  • SAP provides alerts of lock situations, which for transactional locks often needs to be correlated back to the application enqueue objects.  HANA has some historical SNAPSHOT of wait situations, but this is not supportive of historical top down analysis unless someone is actively monitoring current DB locks and SAP enqueue locks in real time.

Simultaneously monitor:

  • Active Batch jobs with selective criteria (Name, User, In-lfight time)

  • Alerts for Long running transactions

  • Active users and their activities

  • Active SAP enqueue objects with their users/transaction

  • R3 Syslog for DB Deadlock events

  • DB alerts for long lock wait situations with Waiter and Transaction ID of Holder

  • SQL Statements

  • DB threads with waiting conditions (Mutex, Semaphore, Exclusive Locks, etc.)

  • Dialog and DB response times

Any of the monitors above can have an exception (known in IT-Conductor as Threshold Overrides or for an Alert matching a filter called Object Template) which triggers an Alert and optional Notification.  Furthermore, a Recovery Action, such as a SQL query or MiniCheck report triggered when the exception is caught.  This can be used for further analysis but giving historical context along with all the metrics and alerts monitored above.

IT-Conductor SAP Monitoring Locks and Performance

IT-Conductor SAP Monitoring Locks and Performance

FREE IT-Conductor Trial to Monitor SAP