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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Improving database performance » Advanced application profiling using diagnostic tracing

 

Change the 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 Create 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.

Example

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.