Show TOC

Exporting SQL Monitor Recordings to a FileLocate this document in the navigation structure

Prerequisites

  • To export SQL Monitor data, you need the authorization profile for displaying SQL Monitor data.

Context

You may wish to export your SQL Monitor recordings from the current system to a local file if you want to analyze them in another system, or if you intend to switch off the SQL monitoring and then delete all collected data. The latter case can arise, for example, if you want to archive the most recent recordings before switching on the SQL monitoring from scratch (for example, after having corrected many SQL issues).

Target Audience
  • ABAP developer
  • AS ABAP system administrators

Procedure

  1. Open the SQL Monitor tool using the transaction code SQLM (/SDF/ZQLM for ST-PI version)
  2. On the initial screen, click the button Export Data or choose the menu item Start of the navigation path SQL Monitor Next navigation step Data Next navigation step Export Data End of the navigation path.
  3. In the selection screen that appears, you have the option of restricting the records to be downloaded.
    Example

    As an SAP customer, you may only be interested in your own custom code packages (Z*, Y*, or own namespaces)

    To download the entire set of SQL Monitor recordings, you only need to accept the default settings.

  4. To start exporting, press F8 or click the corresponding button in the toolbar
  5. Specify the file name and location of the local file to be downloaded.

Results

The downloaded SQL Monitor data is stored in XML format and saved as a zip file on your local drive. In addition to the monitor data, the zip file also includes metadata with table definitions and system information.

Figure 1: Content of a ZIP File

You can upload this file as a so-called SQL Monitor snapshot into the SQL Performance Tuning Worklist tool (SWLT) or the SQL Monitor (SQLM).