Show TOC Start of Content Area

Procedure documentation Managing the SQL Trace  Locate the document in its SAP Library structure

Use

You use this procedure to switch on the SQL Trace for a particular cluster node.

Note

There are no write filters. If the SQL Trace is active for a cluster node, all requests are traced.

Prerequisites

You are in Problem Management Database Open SQL Monitors SQL Trace Administration.

Procedure

Activating and Deactivating the SQL Trace

       1.      Select a cluster node from the list in the Current SQL Trace Status per Cluster Node area.

Note

Cluster node details are displayed with SQL trace statuses, either On with a green LED icon, or Off with a grey LED icon.

       2.      To activate the SQL trace for the cluster node, choose the Switch Trace On button. The SQL Trace is activated for the selected cluster node. To evaluate the trace, choose SQL Trace Evaluation.

More information: Evaluating SQL Traces

       3.      To set additional options for the trace, you use the Trace Options screen area:

...

       To add stack trace information to every written trace record, select the Add Stack Trace checkbox.

       To add stack trace information to trace records that take longer than a certain time period in microseconds only, enter the appropriate value in the Threshold in Micro Seconds field.

       To add stack trace information to trace records that contain matching method name calls only, enter the appropriate value in the Method Name Contains field.

Caution

Method name matching is case-sensitive! You cannot use wildcards in method name matching.

       4.      To deactivate the SQL trace for the cluster node, choose the Switch Trace Off button.

Working with the SQL Trace File

Each time you switch the SQL Trace on, the system generates a new set of files to store trace records so that you can check older traces if necessary. By default, a maximum of 10 files by 10,000,000 bytes each can be created for a single trace.

 

...

       1.      To manage trace files, choose the Administrate Traces tab in the Trace Administration screen area.

       2.      To delete one or more traces, select these traces in the list, and choose the Delete button.

       3.      To download particular traces, select them and choose Download.

End of Content Area