Switching on the SQL Monitor

Prerequisites

To activate servers, you need the authorization profile to perform SQL Monitor administration tasks. See also: Preparations

Context

Switching on the SQL Monitor is server-bound. This means that each instance of the application server has its own activation status. Therefore, the SQL Monitor can be switched on or off for individual servers.

The SQL Monitor can be operated in two ways:

For individual servers
Globally, for all servers of the system

In addition, the expiration date as well as a record limit has has to be defined when you activate servers for monitoring so that the SQL Monitor is switched off automatically. The default setting for the expiration date is to switch off monitoring after 7 days. You can also run the monitoring for 1 day, 1 week, or even for 2 weeks. However, we do not recommend longer periods since the data is aggregated and the quality of data decreases whenever the measured processes or contributing programs have been modified in the meantime.

Target Audience

AS ABAP system administrators

Procedure

Launch the SQL Monitor tool using the transaction code SQLM (/SDF/ZQLM for ST-PI version).
To activate all servers for monitoring (recommended), choose the menu item SQL Monitor Activate All Servers or click the corresponding button in the initial screen.

Note

If you want to switch on the SQL monitoring for individual servers only, choose the menu item SQL Monitor Activate Selected Servers or click the corresponding button in the initial screen.
In the dialog that appears, specify the activation expiry for which the SQL monitoring will be switched off automatically for all servers. Change the default value for Date and Time – if necessary.

Note

The Record Limit is already predefined with a value of 2.000.000. Under normal circumstances, this value will not be reached. This limit is a precautionary measure, used to ensure that the performance of the system is not affected by the SQL Monitor in an uncontrolled fashion. Consequently, you should only increase this value if you have already gained experience with the SQL Monitor and are sure that your system can cope with even larger data volumes.

SQL Monitor actvation expiry dialog

Results

You have switched on the SQL Monitor for the selected servers. To verify the activation status for each server available in the current system, choose the menu item Start of the navigation path SQL Monitor Next navigation step Display Server Details End of the navigation path .

List of Servers Provides Information About the Activation Status for Each Server

Afterwards, you can change the activation schedule any time by choosing the menu item Start of the navigation path SQL Monitor Next navigation step Maintain Deactivation Schedule End of the navigation path .

The following jobs are scheduled or verified automatically when the SQL Monitor is switched on:

RTM_PERIODIC_JOB	Collects data from shared memory and stores it in the database tables. In most cases this job is running anyway (does not depend specifically on the SQL Monitor). Runs periodically once an hour.
SQLM_UPDATE_DATA/SCHEDULE	Replicates data to the SQL Monitor tables. It makes the data collected by the SQL Monitor available for read access. Runs periodically once an hour.
SQLM_DEACTIVATE/SCHEDULE	Runs at the expired date and time that was defined when activating servers for monitoring, so that the SQL Monitor will be switched off automatically.