SQL Trace Filtering 

Use

The SQL Trace stores information about all database calls issued using Open or Native SQL. When evaluating the trace using the SQL Trace Web application, however, you can enter filtering criteria to display only those entries that are relevant for your purposes.

Integration

When you select a trace for evaluation and choose Evaluate, the SQL Trace application redirects you to a filter page, where you can set filtering criteria for the trace list.

Features

You can filter the SQL trace list using:

·        Session Id

Use this option to display only those statements that belong to a particular HTTP session. This option is particularly helpful for viewing SAT (Single Activity Trace) records.

·        DSR Transaction Id

Use this option to display only those statements that belong to a particular DSR (Distributed Statistical Records) transaction. This option is particularly helpful for viewing SAT (Single Activity Trace) records.

·        User

Use this option to display only those statements that have been executed by a particular user – for example, an Administrator.

·        Minimum duration

Use this option to filter out the statements whose execution took less time than the specified period (in microseconds).

·        Application

Use this option to display only statements that have been issued by a particular application.

You must enter the whole name of the application, which also includes the application provider name – for example, sap.com/GettingStartedOpenSQL. You can check the application name in the runtime screen of the Deploy Service in the Visual Administrator.

·        Thread type

Use the available options to display only statements that are executed in system threads or in application threads, or in both types of threads.

In addition to the filtering criteria, you can set the following options for the trace list:

·        Maximum number of records to show

If the records are more than the maximum number, the system suppresses those beyond the limit.

·        Highlighting for statements executed longer than a specified period

The period that you specify is in microseconds.

·        Extended list option

Use this option to view all parameters described in Evaluating the SQL Trace.