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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Monitoring and improving performance » Advanced application profiling using diagnostic tracing » Configuring diagnostic tracing


Changing diagnostic tracing configuration settings

Diagnostic tracing settings are specific to a production database. You use the Database Tracing Wizard in Sybase Central to change diagnostic tracing settings when creating a tracing session. To learn how to start the Database Tracing Wizard, see Creating a diagnostic tracing session.

Diagnostic tracing settings configured in the Database Tracing Wizard do not affect settings or behavior for the Application Profiling Wizard. The settings for the Application Profiling Wizard are pre-configured and cannot be changed.

You can also use the sa_set_tracing_level system procedure to change the diagnostic 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 diagnostic tracing level (Interactive SQL)

  1. Connect to the database as a user with DBA authority or as a user with PROFILE authority.

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


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

CALL sa_set_tracing_level( 1 );

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

Changing diagnostic tracing settings while a tracing session is in progress