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


Determining 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. Connect to the database as a user with DBA authority or as a user with 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.


The following statement shows you how to query the sa_diagnostic_tracing_level diagnostic table to retrieve the current diagnostic tracing settings:

SELECT * FROM sa_diagnostic_tracing_level WHERE enabled = 1;

The following table is an example result set from the query:

id scope identifier trace_type trace_condition value enabled
1 database (NULL) volatile_statistics sample_every 1,000 1
2 database (NULL) nonvolatile_statistics sample_every 60.000 1
3 database (NULL) connection_statistics (NULL) 60,000 1
4 database (NULL) blocking (NULL) (NULL) 1
5 database (NULL) deadlock (NULL) (NULL) 1
6 database (NULL) plans_with_statistics sample_every 2,000 1
See also