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

SQL Anywhere 12.0.0 » 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 preconfigured 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. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or PROFILE authority.

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