Providing Snapshots of SQL Monitor Data

Prerequisites

For creation (or deletion) of snapshots, you need the authorization profile for performing administration tasks in the SWLT transaction. See also: Tool Availability and Technical Requirements

Context

In the SQL Performance Tuning Worklist, you can access the runtime check results from SQL Monitor only by means of SQL snapshots. This means, in particular, you cannot directly access the current SQL Monitor data of the local system.

Instead, snapshots are used to transfer the results of SQL monitoring, for instance from your productive system to the data storage of the Worklist tool. Each individual snapshot is a full copy (if no filter is applied) of all relevant SQL Monitor recordings for a particular period of time. This approach supports the complete decoupling of the generation (SQLM) and the usage of runtime data (SWLT) and enables you to run them in different systems (productive and correction system).

In addition, snapshots also have the advantage that you can access, at any time, fixed data records that will no longer change during your analysis.

Target Audience

AS ABAP system administrators
ABAP developers

To create snapshots, proceed as follows:

Procedure

To access the SQL Performance Tuning Worklist, launch transaction SWLT.
Under the SQL Monitor tab, click the Manage/Create Snapshots button.
Under the Create tab, edit a meaningful short description - in case it should differ from the generated one (SQLM Snapshot [#<SYSTEM>] [#<DATE>] [#<TIME>]).

Use one of the following options to specify the Data Source for the snapshot to be created:

Option	Description
File Import	Specify the location and the name of the zip file, with which you downloaded the SQL Monitor recordings on your local drive. See also: Exporting SQL Monitor Recordings to a File
Remote System	Enter a valid RFC destination for the target system (where the SQL Monitor recordings are stored) in the dedicated entry field and press `ENTER`. Note Normally, you collect the SQL Monitor data in your productive system, whereas the SWLT transaction runs in the development or correction system.
Local System	Use this option in an exceptional case only where you want to run both the SQL Monitor and the SWLT transaction in one and the same system.

Option

Description

File Import

Specify the location and the name of the zip file, with which you downloaded the SQL Monitor recordings on your local drive.

Remote System

Enter a valid RFC destination for the target system (where the SQL Monitor recordings are stored) in the dedicated entry field and press ENTER.

Local System

Use this option in an exceptional case only where you want to run both the SQL Monitor and the SWLT transaction in one and the same system.

Metadata of database tables (such as, number of columns, buffering type, size category, and so on) are displayed within SQL Performance Tuning Worklist along with SQL Monitor data. You can include these metadata into the SQLM snapshots.

Creating a snapshot with SQL Monitor recordings from a remote system

Press F8 or choose Create Snapshot in the toolbar.

Results

You can now assign the snapshot as a data source in the SQL Performance Tuning Worklist.