|
To see the current tracing settings, you start the Database Tracing wizard in Sybase Central. When you are done examining the settings, cancel the wizard. You can also retrieve the tracing settings in effect by querying the sa_diagnostic_tracing_level table.
You can retrieve tracing settings regardless of whether a tracing session is in progress.
Connect to the database as the DBA.
Choose Mode > Application Profiling.
If the Application Profiling wizard appears, click Cancel to close it.
Right-click the database, and choose Tracing from the popup menu.
If this is your first time using tracing, or if you have recently cleared your tracing settings, the Database Tracing wizard appears. Otherwise, you must choose Tracing > Configure and start tracing.
Advance in the wizard until you reach the Edit Tracing Levels page. This page contains the settings currently specified for tracing, even if a tracing session is not in progress.
Click Cancel to leave the wizard once you are done reviewing the settings.
Connect to the database as the DBA.
Query the sa_diagnostic_tracing_level table for rows in which the enabled column contains a 1.
The database server returns the 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 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 |