Diagnostic Monitor (SAP DB) 

This area in the Detail Analysis Menu allows you to start the diagnostic monitor

The diagnostic monitor allows you to perform a runtime analysis of long-running SQL commands within an application.

Function

  

Diagnostics ON

Switches on diagnostic monitor.

Specify the diagnostic options you desire (see "diagnostic options").

Caution: All SQL statements are reparsed as soon as the diagnostic monitor is active.

Diagnostics OFF

Switches off diagnostic monitor

Make sure the diagnostic monitor is switched off after the analysis to stop the system from reparsing the SQL statements.

Clear Monitor Tables

Initializes the monitor tables.

SQL statements and values determined using the WHERE condition in the SQL statement are entered in the SYSMONITOR and SYSMONDATA tables for the corresponding command. These satisfy the diagnostic monitor options and are transmitted to the database system when the diagnostic monitor is switched on. These tables are overwritten cyclically. The SYSMONITOR and SYSMONDATA tables are not initialized when the diagnostic monitor is stopped. Therefore, use the Clear Monitor Tables function instead.

Start Analysis

Analysis of diagnostic monitor data.

Switch Monitor Data On/Off

Activate or deactivate logging of the values for the WHERE condition.

 

Diagnostic Options

After switching on the diagnostic monitor, you can specify criteria for determining how SQL statements are logged in the diagnostic monitor tables.

Option

Default Value

Explanation

SELECTIVITY

1.0 (%)

An SQL statement is logged in the diagnostic monitor tables when the ratio between qualified records and records read exceeds the percentage specified.

READ

10,000

The SQL statement is logged in the diagnostic monitor tables when the number of virtual reads exceeds the number specified.

TIME

1,000 (milliseconds)

The SQL statement is logged in the diagnostic monitor tables when the statement runtime exceeds the number of seconds specified.

Number

255

This value specifies the maximum number of entries held in the SYSMONITOR table before the table is cyclically overwritten.