Preparations

Before using the SQL Monitor tools in an ABAP system, some configuration steps are required.

Target Audience

  • AS ABAP system administrators

Adding Authorizations for SQL Monitor Users

Context

In addition to the authorization for launching the SQL transactions themselves (as a minimum, display authorization profile for object S_DEVELOP (activity: 03) is required), you will need additional SQL Monitor authorizations.

Procedure

  1. Separate users who administrate the SQL Monitor from users who only need to display SQL Monitor data for performance analysis.
  2. Continue according to the following variants:
    Option Description
    For Standard SQL Monitor variant

    1. For the authorization object S_ADMI_FCD (standard authorization object for trace tools like ST05), add the

      • Value SQMA for SQL Monitor administration
      • Value SQMD for read access to SQL Monitor data
    2. Assign the
      • Authorization for transaction code SQLM (SQL Monitor administration)
      • Authorization for transaction code SQLMD (displaying SQL Monitor data)
    For ST-PI add-on variant

    1. For the authorization object S_ADMI_FCD, add the

      • Value ST0M for changing trace switches
      • Value ST0R for analyzing traces
    2. Assign the
      • Authorization for transaction code /SDF/ZQLM (SQL Monitor administration)
      • Authorization for transaction code /SDF/ZQLMD (displaying SQL Monitor data).

Ensuring System Settings for SQL Monitor Are Activated

Context

Before running the SQL Monitor, ensure that the required system setting is activated (default setting).

To check this setting in your system, proceed as follows:

Procedure

  1. Start transaction RZ11.
  2. Check if the profile parameter abap/sqlm/main_switch has the value on (default).