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


Determine current diagnostic tracing settings

Use the Database Tracing Wizard in Sybase Central to view current diagnostic tracing settings. When you are done examining the settings, cancel the wizard. You can also retrieve the diagnostic tracing settings in effect by querying the sa_diagnostic_tracing_level table.

You can retrieve diagnostic tracing settings regardless of whether a tracing session is in progress.

 To determine the current diagnostic tracing settings (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or PROFILE authority.

  2. Choose Mode » Application Profiling. If the Application Profiling Wizard appears, click Cancel.

  3. In the left pane, right-click the database and choose Tracing.

    If the Database Tracing Wizard does not appear, choose Tracing » Configure.

  4. Review the settings currently specified for diagnostic tracing on the Edit Tracing Levels list.

  5. Click Cancel.

 To determine the current diagnostic tracing settings (Interactive SQL)
  1. Connect to the database as a user with DBA authority or as a user with PROFILE authority.

  2. Query the sa_diagnostic_tracing_level table for rows in which the enabled column contains a 1.

    The database server returns the diagnostic tracing settings currently in use. A 1 in the enabled column indicates that the setting is in effect.

 See also