Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Advanced application profiling using diagnostic tracing » Configuring diagnostic tracing

Determining current tracing settings Next Page

Changing tracing configuration settings

Tracing settings are production-database-specific. That is, the tracing settings you configure for a production database do not impact tracing that you perform on another production database. You use the Database Tracing wizard in Sybase Central to change tracing settings when creating a tracing session. To learn how to start the Database Tracing wizard, see Creating a tracing session.

Tracing settings configured in the Database Tracing wizard do not affect settings or behavior for the Application Profiling wizard.

You can also use the sa_set_tracing_level system procedure to change the tracing level. This does not start a tracing session, and fails if a tracing session is already in progress. Also, it does not allow you as much control over other settings such as scopes, conditions, values, and so on. For more information about this procedure, see sa_set_tracing_level system procedure.

To change the tracing level (Interactive SQL)
  1. Connect to the database as the DBA.

  2. Use the sa_set_tracing_level system procedure to set the desired tracing levels.

  3. Example

    The following statement uses the sa_set_tracing_level system procedure to set the tracing level to 1:

    CALL sa_set_tracing_level( 1 );

    Existing tracing settings are overwritten with the default tracing settings associated with tracing level 1. To see the default settings associated with the various tracing levels, see Diagnostic tracing levels.

    Changing tracing settings while a tracing session is in progress