Kontakt

Ansicht
Dokumentation

RS_AMDP_PLANVIZ_TRACE - Prototype: PlanViz Trace for AMDP Calls

RS_AMDP_PLANVIZ_TRACE - Prototype: PlanViz Trace for AMDP Calls

PERFORM Short Reference   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book

Purpose

This program controls PlanViz trace for AMDP calls, i.e. calls to HANA procedures managed by the AMDP framework (ABAP Managed Database Procedures) via the ABAP-Statement CALL METHOD.

It enables PlanViz tracing for procedure calls at runtime of the ABAP application, i.e. in the runtime context of the running ABAP application which may e.g. consist of

  • current content of temporary tables
  • current (uncommitted) content of persistent tables
  • current setting of environment variables
  • ...

As PlanViz trace is expensive and has some influence on statements runtimes, it should be used to analyze already known performance issues, identified e.g. via the ABAP Profiler with included AMDP trace.

As AMDP trace in ABAP profiler has much less impact on HANA runtime, it produces more realistic runtime information which helps to identify the statements to be analyzed further.

Caution

  • This program is is meant for SAP internal usage only. Please do not use it unless proposed by SAP.
  • This program is in a prototype state; it may not work as expected, and there is no support for it. Additionally, it may break on changes of services used by it, and it will be removed later on without further notice.
  • If possible, avoid to use this program in a productive system.
  • If you need to use it in a productive system, you should verify before in a test system with equal or at least similar HANA and ABAP software version, whether
  • enabling the PlanViz trace causes unexpected side-effects on the ABAP application

  • tracing does not slow down the application too much (avoid timeout issues)

  • trace filter possibilities fit to the application scenario to meet tracing restrictions (see below).

  • If necessary, additional filter measures have to be taken to avoid concurrent calls, e.g. using dedicated application users, application servers for the trace, or limiting internal application parallelization.
  • When tracing in productive systems, please avoid to cancel running procedure calls with active PlanViz trace.
  • As trace data volume grows fast, please do not forget to switch off trace as soon as possible, and to delete or cleanup trace data as soon as the analysis is done.

Restrictions

While it is possible in general, please avoid to trace concurrent calls to procedures with PlanViz trace active, as this might cause high load on the database, and would render unrealistic trace results.

PlanViz trace can be controlled only for ABAP->HANA procedure calls, including all nested calls inside the called HANA procedure, i.e. there is no filter for those nested calls.

For further restrictions of this trace, please consult the HANA documentation for PlanViz trace and SQL Analyzer.

This prototype is built to be used via SAPGUI only.

Integration

Prerequisites

The AMDP framework is currently only available on HANA databases. The integrated PlanViz trace is a feature of the HANA database.

Features

Control of PlanViz trace for AMDP calls:

  • Activation of PlanViz trace: Activation info is managed via the ABAP server only, i.e. there is no global PlanViz trace activation on the database, but for each traced AMDP call a new PlanViz context is opened on the current HANA connection, the procedure call is executed, the trace is extracted and stored, and then the PlanViz context is closed again.
  • Predefined filter conditions:
  • ABAP application server: tracing is only controlled for the current application server where this control program is running,

  • ABAP application user calling the AMDP procedure, and

  • Pattern for procedure name(s) to be traced.

  • Deactivation of PlanViz trace.
  • Overview over Trace Activations and Removal of Obsolete Activations

Maintenance of stored PlanViz trace entries

  • Overview of PlanViz trace entries for the current ABAP application user, one entry for each traced ABAP->HANA procedure call.
  • Download of PlanViz trace for analysis by experts, e.g. in special analysis tools, or
  • Direct calls of PlanViz analysis in SAP HANA Studio (requires registration of SAP HANA Studio for the filetype) which acts as a file viewer.
  • Deletion of selected PlanViz trace entries
  • Cleanup of all PlanViz entries for the current ABAP application user

Selection

Standard Variants

Output

Activities

Example






ROGBILLS - Synchronize billing plans   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 5644 Date: 20240601 Time: 183947     sap01-206 ( 72 ms )