Activating the SQL Trace

Procedure

  1. in the SQL Monitor, update the SQL data on your local server using the menu item Start of the navigation pathSQL Monitor Next navigation step Refresh Next navigation step Local Server.End of the navigation path
  2. In the result list of the SQL Monitor, select the line that represents the SQL operation for which you wish to activate the SQL trace.
  3. Click the Activate/Deactivate SQL Trace button in the toolbar.
    Activating the SQL Trace for selected line
    Activating the SQL Trace
  4. In the activation dialog, specify the settings according to your needs, or leave the predefined values unchanged and then click OK to continue.
    Activation dialog

    By use of these settings, you can in particular...

    • limit the SQL tracing to a user and/or a server
    • get the call stacks in addition to the traces by checking SQL Trace with Call Stack
    • limit the tracing to the very request for which the selected line was executed
    • limit the maximal number of SQL traces executed per session (might be important if the executed line lies within a loop).
    Activation dialog

Results

Verify that the selected line turns to green after activation of SQL trace.

Selected line after activation of SQL trace
Selected line after activation of SQL trace