The sa_diagnostic_tracing_level table is owned by the dbo user, and each row in this table is a condition that determines what kind of diagnostic information to send to the tracing database. If a piece of logging data meets the conditions of one or more rows in this table, then the corresponding data is logged.
Data in this table is populated using the CONNECT TRACING or REFRESH TRACING LEVEL statements.
Columns| Column name | Column type | Description |
|---|---|---|
| id | UNSIGNED INT | For internal use only. |
| scope | CHAR(32) |
The scope of the diagnostic tracing, as listed below.
|
| identifier | CHAR(128) |
The identifier for the scope. This value changes, depending on the specified scope. For example:
|
| trace_type | CHAR(32) |
The type of data to trace for the specified scope, as listed below.
|
| trace_condition | CHAR(32) |
Applies only to plans, and controls whether to trace large, expensive queries, or queries for which the optimizer did not make optimal choices. Possible values are listed below.
|
| value | UNSIGNED INT |
The value associated with the condition. For example, if condition is SAMPLE_EVERY, the condition_value would be a positive integer reflecting time in milliseconds. Additional rules are as follows:
|
| enabled | BIT | Whether the row is enabled. That is, whether the tracing settings in the row are active. 1 is enabled; 0 is disabled. |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |